Defining Character set UTF-8 in SQL statements

[basavannasv]

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

[Anonymous]

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]

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]

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]

Change locale as on picture, but for your language.

[marcus_sommer]

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

- Marcus

[Naor_ISR]

Hi, did you fix the problem?