Re: Migration from sqlserver to oracle 8i: character set conversionproblems

Irmen de Jong wrote:

> Hello
> we're trying to migrate a SQLserver 2000 database to Oracle 8i.
> The SQLserver database has some columns with unicode text in them,
> such as the euro character (€).
>
> The Migration Workbench transforms these characters in wrong
> characters in the oracle columns (? and ¿).
>
> The column type in the SQL server database is NVARCHAR,
> the column type in the Oracle database is VARCHAR2.
>
> How can we make the Migration Workbench use Unicode to
> transfer the texts?
>
> The sql migration scripts that can be generated from the Migration
> workbench use sqlserver's bcp.exe to dump the source tables.
> It looks like bcp is called WITHOUT the '-w' option, and it
> creates faulty data files (wrong characters).
> When using the '-w' option by hand, it outputs unicode data
> files (with correct characters). How can we enable this switch
> in the Migration Workbench?
>
> Thanks!
>
> Irmen de Jong
> Everest b.v.

[Quoted] [Quoted] This has nothing to do with column types, VARCHAR2 or NVARCHAR. It has [Quoted] to do with the character set of the database.

Go to http://tahiti.oracle.com and search on CHARACTER SET.

Daniel Morgan Received on Tue Feb 18 2003 - 15:38:04 CET