Re: SQLServer2k to Oracle 9i, Character Set Conflict

On 9 Jul 2004 04:49:56 -0700, xtanto_at_hotmail.com (Krist) wrote:

>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

MSWIN1252

--
Sybrand Bakker, Senior Oracle DBA