Hello,
We have received source file having French character. Our job is a simple job
Read File => Transform => Load Teradata
We have used NLS at Job level as ASCL_ISO8859-1.
In Teradata connector we have used client character set as UTF-8.
When I run the job, French character data gets processed successfully to Teradata (v 13.10) but job is throwing a warning:
Conversion from the ASCL_ISO8859-1 character set to UTF-8 may affect performance
I have tried changing client character set to "ASCII" but still warning is there.
Column where French data is loaded is Latin. Do I need to convert to Unicode?
When I check client character set on Teradat database using
Sel * from DBC.chartranslations
Its showing me ASCII.
Some suggestion on DSxchange i found to have
NLS_SESSION =AMERICAN_AMERICA.WE8ISO8859P1
NLS_MAP=ISO8859-1
Please help.
Loading French character to Teradata 13.10
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 67
- Joined: Thu Apr 06, 2006 7:13 am
Loading French character to Teradata 13.10
Bhaskar Jha
-
- Participant
- Posts: 32
- Joined: Tue Dec 13, 2011 7:27 am
Re: Loading French character to Teradata 13.10
Give a try with these changes to parameters in teradata connector:
client character set -ASCII
Automap characterset encoding - No
NLS Map Name - ASCL_ISO8859-1(same NLS using at job level)
Maximum bytes per character -1
Thanks,
Vinay.
client character set -ASCII
Automap characterset encoding - No
NLS Map Name - ASCL_ISO8859-1(same NLS using at job level)
Maximum bytes per character -1
Thanks,
Vinay.