Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III

Accent problem with TeradataInput and tFileOutputDelimited

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.
Labels (3)
6 Replies
Anonymous
Not applicable

Can you post here component's properties screen shot here ?
Charly1
Contributor II

Connection properties :
0683p000009MCg6.jpg
FileOutPut properties:
0683p000009MCgk.jpg
Anonymous
Not applicable

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
 
Charly1
Contributor II

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.
Anonymous
Not applicable

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
Charly1
Contributor II

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