topic Re: foreign language issue in QlikView

foreign language issue

Tue, 26 Mar 2013 10:28:45 GMT

Need your help,

I am having a dimenssion say ABC in this ABC there are the data text which are in foreign languages(e.g. Japan, China and so on) and in English as well .

While uloading the data in QVW this texts are showing as a square box, not able to recognize them.

Could you please provide me any resolution on this how to show them in their repective language?

e.g. オートデスク it is showing as [] [] [] [] []

Note: English text should be show as in English.

Re: foreign language issue

Gysbert_Wassenaar — Tue, 26 Mar 2013 18:46:20 GMT

If you load from text files (.csv, .txt, ...etc) then you probably need to specify utf8 as character set.

TestTable:

LOAD *

FROM test.csv

(txt, utf8, embedded labels, delimiter is ',', msq);

Other options if utf8 doesn't work are unicode and CodePage is N. You can find a list of code pages here.

Re: foreign language issue

Fri, 29 Mar 2013 15:22:02 GMT

Hi Gysbert,

!!! No Luuck!!! I have tried by uploading the file with CSV format also specify the ut8 as character set but still it is not working.

FYI i am uploading the data from QVD & excel.

Re: foreign language issue

hic — Sat, 30 Mar 2013 22:59:10 GMT

As Gysbert points out, you need to load the data correctly, i.e. with the 'Utf8' or 'Unicode' switch. Then you also need to choose a font (in the list box) that is able to show unicode characters, e.g 'Arial Unicode MS'.

HIC

Re: foreign language issue

Mon, 01 Apr 2013 10:40:13 GMT

Thanks a lot Henric

It got resolved.