Re: NTEXT problem when Migrating from MSSQL to Oracle

On 15 Aug 2002 11:58:34 -0700, jusungyang_at_yahoo.com (Jusung Yang) wrote:

>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?

I solved my problem. Migration Workbench converts NTEXT to CLOB. But it doesn't do it well. I converted my NTEXT to TEXT on the SQL Server side. That seemed to do the trick. Received on Thu Aug 15 2002 - 21:44:00 CEST