You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » CSV Imported With Weird Characters
#1 2011-04-22 21:06:16
- captainlaw
- Member
- Registered: 2009-11-10
- Posts: 81
CSV Imported With Weird Characters
Hello,
I'm trying to import a straight csv file into a sql server table using tFileInputDelimited into tMSSqlOutput.
However, I'm experiencing weird characters imported related to "apostrophe". See example below.
Source String (TRAVELALERTS.CA - INT’L FLIGHT-EN)
Data Issue – Weird Characters imported (TRAVELALERTS.CA - INTâ??L FLIGHT-EN)
Culprit – During Talend Import
Any settings in Talend that I can workaround this data issue?
Much appreciate your help!
Offline
#2 2011-04-22 21:32:11
- captainlaw
- Member
- Registered: 2009-11-10
- Posts: 81
Re: CSV Imported With Weird Characters
Another related issue. in tFileInputDelimited, I set Schema to use a "Repository", but for some reason, after each Talend run, it reverts it back to "Built-In". Any reason why it would get switched back automatically?
Thanks for your help in advanced.
Offline
#3 2011-04-22 22:18:37
- JohnGarrettMartin
- Member
- Registered: 2009-01-07
- Posts: 781
Re: CSV Imported With Weird Characters
Dont know about the schema reverting to built-in. thats either a bug or you doing something wrong 
The Data Issue is most likely due to your encoding or locale settings. Try setting the file and database encoding to UTF8 and see if you still get bad data.
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » CSV Imported With Weird Characters