Loading French character to Teradata 13.10

[bhaskarjha]

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.

[adityavinay]

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.