SQLServer2k to Oracle 9i, Character Set Conflict

From: Krist <xtanto_at_hotmail.com>
Date: 9 Jul 2004 04:49:56 -0700
Message-ID: <cb48a3b.0407090349.37ef2369@posting.google.com>

Hi All,

I am migrating SQLServer2000(Win2000) to Oracle 9i(AIX) using OMWB. There some problems :
- CHAR(8) in MSSQL must be transffered to CHAR(20) in Oracle This column has Non english encrypted character . If I dont make the oracle column CHAR(20), I will get : ORA-01401 -> inserted value too large for column..

Is this all about character set problem ??

I check in Oracle :
NLS_CHARACTERSET = WE8ISO8859P1
NLS_NCHAR_CHARACTERSET = AL16UTF16 I check in SQL Server :
sp_helpsort =>
Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
width-insensitive for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode Data

If in SQLServer I get the above character set, what Character set should I use in Oracle ?

Thank you for your help,
Krist Received on Fri Jul 09 2004 - 06:49:56 CDT