Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
When i load the data from database, all non-english data is showing as '????'. I need to change the character set to UTF-8, can you suggest how to do that?
looking into the qlik sense documentation i found the format for .txt file but could not get help for SQL statements
thanks in advance
I think we should resolve it from ODBC end. Check if this content can help you.
https://support.microsoft.com/en-au/help/232580/description-of-storing-utf-8-data-in-sql-server
Hi.. thanks for your response.
I again tried changing the character set in ODBC to utf8 in ODBC but while loading the data to Qlik sense I could see '????' value has been replaced with some bad characters something like below...
ÑÂþóûðÑÂþòðть ðýтøòøруѠõû÷õт ÿрþóрðüüþù ûõýþòþ
I believe we need to let Qlik sense know through data load editor... ?
Maybe this one is helpful: Re: Chargement de fichier avec des caractères.
- Marcus
Hi Marcus,
I tried with setting charset to utf8 but no luck.. as i mentioned, i used to get something like below after changing the charset.
ÑÂþóûðÑÂþòðть ðýтøòøруѠõû÷õт ÿрþóрðüüþù ûõýþòþ
thanks.
Change locale as on picture, but for your language.
Another way might be this: Re: Codificação UTF8.
- Marcus