Loading French character to Teradata 13.10
Posted: Tue Jul 16, 2013 4:38 am
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.
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.