COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: cog_ta_user on 29 Mar 2015 06:09:44 PM

Title: Special Characters in CSV input
Post by: cog_ta_user on 29 Mar 2015 06:09:44 PM
Hi there,

I am using CSV file as data source.  The file contains some special characters. eg "Mähönen". What encoding and character set I am using in SQLTXT def file is 'UTF8'. But this doesn't work, it is presented as "M?h?nen". Funny thing is the same data in the other CSV file is processed correctly with UTF8. I wonder if anyone comes across the similar situation, and figured out what the right encoding and character set are recommended to use?

Thanks very much.