Unable to load the Latin Tilde characters into Teradata

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

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.
Top
kshah9
Participant
Posts: 7
Joined: Wed Oct 06, 2010 11:32 am
Location: Pune

Post by kshah9 »

Ray, Thanks for reply, But in Table is created as Latin and in NLs is already to ISO-8859-1. But still facing the problem.
Best Regards,
Kunal Shah
Top
kwwilliams
Participant
Posts: 437
Joined: Fri Oct 21, 2005 10:00 pm

Post by kwwilliams »

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.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”