topic UTF8 issue when querying mysql DB in QlikView https://community.qlik.com/t5/QlikView/UTF8-issue-when-querying-mysql-DB/m-p/424765#M696397 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>currently I'm facing an issue with (german) UTF8 characters not being displayed correctly. My app pulls</P><P>data from MS-SQL (works as expected) and from mysql (borking up the german mutated vowels), both using ODBC. </P><P>I am aware of&nbsp; several post in this forum discussing similar issues.</P><P></P><P>So far I have tried:</P><P>- setting character set in ODBC settings</P><P>- using convert (field, latin1)</P><P>- using COLLATE statement in SQL</P><P></P><P>none of these steps worked out so far.</P><P></P><P>I'd highly aprreciate any hint you guys could provide on how to fix this issue.</P><P></P><P>Thanks in advance,</P><P></P><P>W</P></BODY></HTML> Fri, 03 May 2013 19:15:21 GMT 2013-05-03T19:15:21Z UTF8 issue when querying mysql DB https://community.qlik.com/t5/QlikView/UTF8-issue-when-querying-mysql-DB/m-p/424765#M696397 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>currently I'm facing an issue with (german) UTF8 characters not being displayed correctly. My app pulls</P><P>data from MS-SQL (works as expected) and from mysql (borking up the german mutated vowels), both using ODBC. </P><P>I am aware of&nbsp; several post in this forum discussing similar issues.</P><P></P><P>So far I have tried:</P><P>- setting character set in ODBC settings</P><P>- using convert (field, latin1)</P><P>- using COLLATE statement in SQL</P><P></P><P>none of these steps worked out so far.</P><P></P><P>I'd highly aprreciate any hint you guys could provide on how to fix this issue.</P><P></P><P>Thanks in advance,</P><P></P><P>W</P></BODY></HTML> Fri, 03 May 2013 19:15:21 GMT https://community.qlik.com/t5/QlikView/UTF8-issue-when-querying-mysql-DB/m-p/424765#M696397 2013-05-03T19:15:21Z