VARCHAR converting to NVARCHAR

sreeramkumart · Post by **sreeramkumart** » Fri Dec 21, 2007 4:17 am

Hi,

When i am using Run Time Column propagation, all the columns having data type VARCHAR are converting to NVARCHAR. I do not want to convert the datatype.

I need to stop this in job level not in administrator level. Is it possible? Please let me know.

Thanks,
Sreeram

throbinson · Post by **throbinson** » Fri Dec 21, 2007 6:51 am

How is the Metadata defined for these columns in the sources and the targets of the job?

sreeramkumart · Post by **sreeramkumart** » Sun Dec 23, 2007 11:20 pm

We are giving the table name in Read method in Oracle Stage and not defining any columns expecting it will pick all the columns of the table and propagate, It is working but only issue is it is making all the varachar columns as Nvarchar.

sreeramkumart · Post by **sreeramkumart** » Sun Dec 23, 2007 11:22 pm

We are giving the table name in Read method in Oracle Stage and not defining any columns expecting it will pick all the columns of the table and propagate, It is working but only issue is it is making all the varachar columns as Nvarchar.

ray.wurlod · Post by **ray.wurlod** » Mon Dec 24, 2007 12:52 am

I am guessing that you have NLS enabled, and that therefore DataStage is expecting to work with Unicode data and will take every opportunity (such as during runtime column propagation) to do so.

If you don't like it, disable RCP and specify your data types explicitly.

sreeramkumart · Post by **sreeramkumart** » Mon Dec 24, 2007 4:20 am

NLS is enabled for my project. How to override the project level settings at job level to make NLS disabled.

ray.wurlod · Post by **ray.wurlod** » Mon Dec 24, 2007 2:47 pm

Each (well, most) stage type has an NLS tab.

sreeramkumart · Post by **sreeramkumart** » Wed Dec 26, 2007 12:08 am

Thanks for your reply Ray, But I am not able to find any values that we can set the NLS disable in the oracle stage, There are lot of other codes available Can anyone let me know which one I have to select to make the NLS Character disabeld.

ray.wurlod · Post by **ray.wurlod** » Wed Dec 26, 2007 1:38 pm

There is a pseudo-map called NONE. Might be worth trying that.

edwds · Post by **edwds** » Tue Feb 26, 2008 4:04 pm

Does the Oracle Bulk Loader stage support NVARCHAR2 and NCHAR without NLS being enabled?