topic Re: Re: Hebrew charcters on Qlikview data in QlikView

Hebrew charcters on Qlikview data

Tue, 27 Aug 2013 12:22:06 GMT

Hello,

I use ODBC for accessing data from mySQL.

I have data in Hebrew and it is shown in Giberish.

I already have tried to change the ODBC Charcter set to hebrew but there's still Giberish.

I would like to get any advice.

Thanks,

Nimrod

ariel_klien — Tue, 27 Aug 2013 13:52:56 GMT

Hi Nimrod,

I don't think that the problem is in the ODBC.

can you attach QVD with Hebrew data?

Ariel

Tue, 27 Aug 2013 14:36:55 GMT

I attached the example.

Thanks for your response.

ariel_klien — Wed, 28 Aug 2013 06:48:56 GMT

hi,

I can't do anything with your example.

If you load inline with Hebrew do you see Giberish as well?

try to load this:

LOAD * INLINE [

A, B

שלום, להתראות

אני, אתה

מה, קורה

];

what do you see?

Ariel

Wed, 28 Aug 2013 07:03:05 GMT

I see Hebrew.

Wed, 28 Aug 2013 07:11:36 GMT

I solved it by changing from ANSI driverto UNICODE driver.