You are not logged in.
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!
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.
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.