topic Re: Accent problem with TeradataInput and tFileOutputDelimited in Talend Studio

Accent problem with TeradataInput and tFileOutputDelimited

_AnonymousUser — Sat, 16 Nov 2024 10:54:20 GMT

Hello,
Excuse me for my poor English.
I try to export data from teradata database to multiple CSV files.
I need to keep accents on my csv files, but i cant do it.
I use :
TeradataConnection > TeradataInput > tMap > FileOutputDelimited (x3)
When I use ISO encodage I got "?" in the place of accents.
When I use UTF8 encodage I got "ï¿½"
I try to change the Encodage in :
- The FileOuput composant.
- The Connection composant with : characterEncoding.
- The Workspace preference.

Re: Accent problem with TeradataInput and tFileOutputDelimited

Anonymous — Wed, 16 Dec 2015 10:40:14 GMT

Can you post here component's properties screen shot here ?

Re: Accent problem with TeradataInput and tFileOutputDelimited

Charly1 — Wed, 16 Dec 2015 10:54:40 GMT

Connection properties :

FileOutPut properties:

Re: Accent problem with TeradataInput and tFileOutputDelimited

Anonymous — Thu, 17 Dec 2015 02:59:32 GMT

Hi CharlyFR,
Have you tried to add the parameter "Dfile.encoding=utf-8" to the JVM parameters to see if it works?
Best regards
Sabrina

Re: Accent problem with TeradataInput and tFileOutputDelimited

Charly1 — Thu, 17 Dec 2015 09:32:04 GMT

Hi xdshi and thanks for your help,
I try to add "Dfile.encoding=utf-8" to the JVM parameters, But i got the same result : "ï¿½" in place of accents.
Charly.

Re: Accent problem with TeradataInput and tFileOutputDelimited

Anonymous — Fri, 18 Dec 2015 02:59:53 GMT

Hi,
Have you already also added the parameter in "Additional JDBC parameters" of tTeradataInput component? What does your expected accents look like?
Best regards
Sabrina

Re: Accent problem with TeradataInput and tFileOutputDelimited

Charly1 — Fri, 18 Dec 2015 14:49:36 GMT

Hi,
I try to add characterEncoding in JDBC parameters of tTerdataInput but always got " ï¿½" in place of accents, my accent look like "é"
I try to run tTeradataInput solo with result in console (tlogrow) and in console i got this caracter " ï¿½" in place of accent too :
Charly