Page 1 of 1

SQLServer has NChar but Datastage does not have NLS

Posted: Tue May 15, 2007 7:22 am
by Thamilton
I need to read/write to a table with columns that are NVarchar & NChar. This is a database froma vendor. We don't have the need to implement these datatypes in our day to day business.

Is there a way to read/write to the columns without installing NLS?

Posted: Tue May 15, 2007 8:33 am
by DSguru2B
Just switch NVARCHAR to VARCHAR and NCHAR to CHAR in your job.