Re: Migration from sqlserver to oracle 8i: character set conversion problems

Irmen de Jong wrote:

> How can we make the Migration Workbench use Unicode to
> transfer the texts?

We solved it. Don't know if it's the best solution, but this works and is quick:

0) don't use Migration workbench to migrate table data! instead:
1) use sqlserver's bcp.exe with the -w option to generate UTF16 data dump
2) use a script to convert the UTF16 data dumps to UTF8
3) use sqlldr with "CHARACTERSET UTF8" in the control files to read the UTF8 

Irmen de Jong Received on Thu Feb 20 2003 - 22:17:55 CET