Re: char set conversion

Stephan,

The INTERNAL_USE keyword means that your data will not be physically changed. To translate your special characters you would be required to do an export/import.

Also be very careful when checking special characters that you have your client NLS_LANG parameter set correctly or they will look like garbage even if they are in fact correct. One way to check is to cut and paste them into notepad and save as HTML then open it in a web browser and change the encoding you are using (Left click in explorer).

Kind Regards,

Fraser McCallum
MVP Oracle Administration
www.brainbench.com

"Stephan Bressler" <stephan.bressler_at_siemens.com> wrote in message news:b4726v$fvd$1_at_news.mch.sbs.de...
> Hi,
> we we required to change the char set of or database (8.1.7.4, solaris
> 64bit) from we8iso8859p15 to we8mswin1252 using the following command
> sequence:
> STARTUP MOUNT;
> ALTER SYSTEM ENABLE RESTRICTED SESSION;
> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
> ALTER SYSTEM SET AQ_TM_PROCESSES=0;
> ALTER DATABASE OPEN;
> alter database uni character set INTERNAL_USE WE8MSWIN1252;
> alter database uni national character set INTERNAL_USE WE8MSWIN1252;
>
> I'm not happy with this for we8mswin1252 in no real superset (in oracle's
> terminology) of we8iso8859p15. I ran the csscan utility and it complained
> about a lot of data entries. I checked some of them, but the problems are
> special chars, which are wrong anyway.
>
> Did somebody use the above command sequence? Any experiences?
> I looked for the code table of both char sets, but didn't find one. Where
> can I find them?
>
> TIA
> Stephan Bressler
>
>
Received on Thu Mar 06 2003 - 05:03:08 CST