Unable to load the Latin Tilde characters into Teradata
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Verify how character storage is encoded into your Teradata table (perhaps via a SHOW TABLE command) and match that in your DataStage NLS map setting. Probably one of ISO8859-1 or UTF-8 will fill the bill.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 437
- Joined: Fri Oct 21, 2005 10:00 pm
The name field should be set to Unicode in Teradata and not Latin. And the SQL Server NLS is not ISO-8859-1, it is likely windows-1252. Windows 1252 was developed before the Latin-1 and is a superset of Latin-1. Once you have the column set to Unicode and the NLS MAP set to windows-1252, and then client character set to UTF8 your job should run succesfully.
Keith Williams
keith@peacefieldinc.com
keith@peacefieldinc.com