Re: ASCII / EBCDIC issue

Thanks for the discussion anyway.

For those who are interested, ONLY the following DATABASE character sets are supported on mainframe (all EBCDIC):

Language     OS/390 Client Character Set    OS/390 Server Character Set
Arabic       AR8EBCDICX                     AR8EBCDIC420S
Baltic (1)   BLT8EBCDIC1112                 BLT8EBCDIC1112S
Cyrillic (1) CL8EBCDIC1025                  CL8EBCDIC1025R*
Eastern European (1)  EE8EBCDIC870          EE8EBCDIC870S
Greek        EL8EBCDIC875                   EL8EBCDIC875R*
Hebrew       IW8EBCDIC424                   IW8EBCDIC424S
Icelandic    WE8EBCDIC871                   WE8EBCDIC871S
Japanese     JA16DBCS                       JA16DBCS (2)
Korean       KO16DBCS                       KO16DBCS (2)
Simplified Chinese  ZHS16DBCS               ZHS16DBCS (2)
Thai         TH8TISEBCDIC                   TH8TISEBCDICS
Traditional Chinese  ZHT16DBCS              ZHT16DBCS (2)
Turkish      TR8EBCDIC1026                  TR8EBCDIC1026S
Western European (a)  (3)                   WE8EBCDIC1047

The last one is the default, if you do not specify a character set.

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:40c4d2f7$0$8987$afc38c87_at_news.optusnet.com.au...
>
> "Luc Gyselinck" <Luc.Gyselinck_at_nospampandora.be> wrote in message
> news:%l4xc.147847$Nn7.7534710_at_phobos.telenet-ops.be...
> > "Why not re-create the database using AL32UTF8 as the character set?"
> >
> > On the mainframe, z/OS native, choosing this database character set
> results
> > in an ORA-12706 error...
> >
> > ORA-12706 this CREATE DATABASE character set is not allowed
> >
> > Cause: An attempt was made to create a database on an ASCII-based
machine
> > using an EBCDIC-based character set or vice versa. This is not
permitted.
> >
> > Action: Create the database using either ASCII-based or EBCDIC-based
> > character sets, depending on what is supported by the hardware. Refer to
> > your Oracle operating system-specific documentation for more information
> > about the type of character set supported.
> >
> > The NATIONAL character set can be set to AL32UTF8 (the default), but we
> had
> > to set it to UTF8: after the upgrade from Oracle8i to Oracle9i, the
> Forms6i
> > application generated a lot of ORA-00600 on the database and/or some
data
> > was incorrectly handled by Forms. An upgrade to Forms10g is planned for
> mid
> > July (the application has been upgraded and tested and is now in the
> > acceptance fase).
> >
> > Luc
>
> Ah well. Just ignore me then. You've obviously done your homework (and I
> haven't!).
>
> Hopefully someone else will have some suggestions to make about your
> original post.
>
> Sorry for butting in.
>
> Regards
> HJR
>
>
Received on Mon Jun 07 2004 - 15:49:39 CDT