Import from csv (utf-8) - character encoding issues
963952Oct 1 2012 — edited Oct 10 2012Hello,
I've added and reverse engineered csv file to my project - as flat file source and I have prolems with character encoding. If I click "View data", national characters are displayed incorrectly. The same incorrect characters are saved to database (oracle table). How can I set correct encoding for flat file to get correct data, display it correctly in odi studio and handle them correctly when saving to database? I can't see any encoding settings for flat file. Where it should be set?