Re: NTEXT problem when Migrating from MSSQL to Oracle
Date: 15 Aug 2002 11:58:34 -0700
Message-ID: <42ffa8fa.0208151058.54c01475_at_posting.google.com>
[Quoted] Last time I used the Migration Work Bench was last year. Can not remember all the details now. But there are default data type conversions within the tool that can be modified. Look up the data type conversion menu and see what type NTEXT is being mapped to. NTEXT is of course the unicode version of TEXT. I used to cnvert it to CLOB and use UTF8 on the database level.
abc_at_iom.com wrote in message news:<3d5b40f2.24266323_at_news.sf.sbcglobal.net>...
> I'm using the 9.2 release of the Migration workbench to migrate
> SQL2000 data. Oracle does not convert my memo (NTEXT) fields
> properly. What I get is a bunch of numbers (HEX) instead of alpha
> characters. Everything in the documentation says it should work.
> Anybody else have this problem?
Received on Thu Aug 15 2002 - 20:58:34 CEST