Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
basavannasv
Contributor
Contributor

Defining Character set UTF-8 in SQL statements

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

http://help.qlik.com/en-US/sense/1.1/Subsystems/Hub/Content/Scripting/ScriptSpecifiers/CharacterSet....

thanks in advance

7 Replies
Anonymous
Not applicable

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

basavannasv
Contributor
Contributor
Author

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... ?

marcus_sommer

Maybe this one is helpful: Re: Chargement de fichier avec des caractères.

- Marcus

basavannasv
Contributor
Contributor
Author

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.

Vasiliy_Beshentsev
Creator III
Creator III

Change locale as on picture, but for your language.11.png

marcus_sommer

Another way might be this: Re: Codificação UTF8.

- Marcus

Naor_ISR
Contributor II
Contributor II

Hi, did you fix the problem?