Re: ASCII / EBCDIC issue

"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:41:46 CDT