- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
QLikView, ODBC and UTF-8
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have no MySQL available, but could you not use something like
SELECT
CONVERT(Myfield USING Latin1) ,
...
FROM
MyTable;
OR
SELECT
MyField COLLATE latin1_General_CS
...
FROM
MyTable;
Cheers
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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).