char set conversion

From: Stephan Bressler <stephan.bressler_at_siemens.com>
Date: Thu, 6 Mar 2003 09:53:10 +0100
Message-ID: <b4726v$fvd$1@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 - 02:53:10 CST