Looksup with SQL Server nchar&nvarchar

ds_is_fun · Post by **ds_is_fun** » Tue Dec 18, 2007 9:55 pm

We moved data from JDE DB2 whose type was CHAR into Sql Server NCHAR. SQL server uses 2 bytes for NCHAR and NVARCHAR.

If CHAR 10 needs to be moved into NCHAR10 then what is the right lenght in Datastage for table def-
A. CHAR10 to NCHAR10 (OR)
B. CHAR10 to NCHAR20

If I was performing a lookup on NCHAR10 to NVARCHAR10.
A. Would I need to convert NCHAR10 to NVARCHAR10 and then perform a lookup?
(OR)
B. NVARCHAR10 to NCHAR10 and then perform a lookup.

Thanks!

ray.wurlod · Post by **ray.wurlod** » Wed Dec 19, 2007 1:01 am

Import the SQL Server table definition and use whatever is imported.