
Specialist III
2015-12-16
05:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
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.
404 Views
6 Replies

Anonymous
Not applicable
2015-12-16
05:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you post here component's properties screen shot here ?
404 Views

Contributor II
2015-12-16
05:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Connection properties :
FileOutPut properties:
FileOutPut properties:
404 Views

Anonymous
Not applicable
2015-12-16
09:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Have you tried to add the parameter "Dfile.encoding=utf-8" to the JVM parameters to see if it works?
Best regards
Sabrina
404 Views

Contributor II
2015-12-17
04:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
I try to add "Dfile.encoding=utf-8" to the JVM parameters, But i got the same result : "�" in place of accents.
Charly.
404 Views

Anonymous
Not applicable
2015-12-17
09:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Have you already also added the parameter in "Additional JDBC parameters" of tTeradataInput component? What does your expected accents look like?
Best regards
Sabrina
404 Views

Contributor II
2015-12-18
09:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
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
404 Views
