topic Re: QLikView, ODBC and UTF-8 in QlikView

QLikView, ODBC and UTF-8

Thu, 14 Jun 2012 06:16:45 GMT

Hi,

I've tried many ways to show utf-8 characters from database, with no luck.

So all utf-8 characters are "broken" in our QV, i.e. "lÃ¤Ã¤kÃ¤rinvast.otto" should really be "lääkärinvast.otto".

We load data via ODBC from MySQL database. Database and all it's tables are in UTF-8 format.

what I've tried so far:

change ODBC driver charset to utf-8/latin -> no luck.
used SQL statement in QV script

SQL SET character_set_results='latin1';

SQL SET character_set_client='latin1';

changed QV export charset to utf-8

please help!

Thanks in advance!

Re: QLikView, ODBC and UTF-8

Tue, 02 Apr 2013 14:58:02 GMT

Hi,

I have the same issue as ilaririchargt.

I'm querying an Oracle database which contains strings in UTF-8 characters. Currently, the russian text is appearing as ¿¿¿¿¿¿¿¿ ¿¿¿¿¿¿¿.

Did you manage to solve your problem.

Any feedback is highly appreciated!

Regards.

Re: QLikView, ODBC and UTF-8

Tue, 02 Apr 2013 15:42:51 GMT

I have no MySQL available, but could you not use something like

SELECT

CONVERT(Myfield USING Latin1) ,

...

FROM

MyTable;

SELECT

MyField COLLATE latin1_General_CS

...

FROM

MyTable;

Cheers

Re: QLikView, ODBC and UTF-8

Wed, 03 Apr 2013 07:09:13 GMT

Could this be a setting of some sort?

I'm running the query from the QV Server edition (small business) with a leased license on QV Personal and get garbage text instead of russian.

A colleague of mine, testing the same problem on QV Personal, with the same query on the same database, gets the normal russian text.

Cheers.

Re: QLikView, ODBC and UTF-8

EIndriksonsRD — Thu, 12 May 2022 10:33:03 GMT

For whoever is having the same problem I found another solution here: https://docs.oracle.com/cd/B19306_01/install.102/b14312/gblsupp.htm

Changing local Oracle client character set to UTF-8 resolved the issue and you can do it by adjusting registry entry HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEID\NLS_LANG by changing the character set to AL32UTF8 (after the dot).