Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQLServer2k to Oracle 9i, Character Set Conflict
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
What makes you think you want to use CHAR(20) in Oracle?
Are you making an assumption that they are the same or have you actually researched this? I would strongly urge you to not just make the assumption that what you are doing makes sense and to consider using the VARCHAR2 data type.
Daniel Morgan Received on Fri Jul 09 2004 - 17:53:54 CDT