Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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?