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!
Looksup with SQL Server nchar&nvarchar
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: