Char to Nchar while import

Ragunathan Gunasekaran · Thu May 06, 2010 11:04 am

Hi ,
I am importing an oracle table metadata as ODBC table definition. I could see that datastage is importing the char and varchar columns in oracle as Nchar and Nvarchar columns automaticaly.

Is there any reason why this conversion is happening and any way to stop this .?

Kind help is appreciated.

ray.wurlod · Post by **ray.wurlod** » Thu May 06, 2010 4:54 pm

The reason that the conversion is happening is simply that you have NLS enabled.

Ragunathan Gunasekaran · Fri May 07, 2010 7:28 am

Do i need to turn this off ..? would this be in anyway helpfull to me ..?

ray.wurlod · Post by **ray.wurlod** » Fri May 07, 2010 5:03 pm

No you don't have to turn it off, but the importer will always assume Unicode while it is on. You can edit the imported table definitions if you prefer.