Re: SQLServer2k to Oracle 9i, Character Set Conflict

Hi Sybrand,
Thanks for your reply.

> MSWIN1252

Is it MSWIN1252 ot WE8MSWIN1252 ?
So what should I do with the oracle ? Is recreating the database is the only way ? Can I just change the NLS_LANG in the client or in INIT.Ora ?

On other table, SQL Server CHAR(50) must be changed to CHAR(100) in Oracle, But in this column ALL are English standard character, No Special character. is this also because of character set issue or other issue ?

Thanks for your help,
Krist

Sybrand Bakker <sybrandb_at_hccnet.nl> wrote in message news:<ukote09dlftbh1gofsqcit7ppugft1m3dg_at_4ax.com>...
> 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
Received on Fri Jul 09 2004 - 22:42:27 CDT