topic Re: Language Issue in QlikView

Language Issue

amit_saini — Wed, 06 Dec 2017 10:48:03 GMT

Hi Folks ,

I'm having below scenario, I'm having one field in data base as "Reason_Name" and users are entering text in their local language .

I'm simply calling this filed like below:

Actually in above screenshot the content is in Chinese ,but it showing not sure in what format. Any idea how to get this in Chinese language???

Regards,

Re: Language Issue

YoussefBelloum — Wed, 06 Dec 2017 12:49:34 GMT

Hi,

I found that they suggest to use the (UTF-8) as character set, maybe you should try to do it in your database.

Re: Language Issue

amit_saini — Thu, 07 Dec 2017 05:22:14 GMT

Any change if we can handle this from QlikView side???

Regards,

Re: Language Issue

YoussefBelloum — Thu, 07 Dec 2017 09:39:10 GMT

I don't really know, but never tried to changer character set when loading a table from a database (don't know if it is possible)

Re: Language Issue

Anil_Babu_Samineni — Thu, 07 Dec 2017 09:52:47 GMT

But few names in english only. Can you attach image / sample data so then we will try in our machine

Re: Language Issue

amit_saini — Thu, 07 Dec 2017 11:52:44 GMT

Hi Anil,

Below is sample data:

Date	Reason_Name
04.12.2017	DC-Supplied component NGÃ¦ÂÂ¥Ã¦Â–Â™Ã¤Â¸ÂÃ¨Â‰Â¯
04.12.2017	QC-QC samplingÃ¥Â®ÂžÃ©ÂªÂŒÃ¥ÂÂ–Ã¦Â Â·
04.12.2017	SD-Surface damagedÃ¨Â¡Â¨Ã©ÂÂ¢Ã§Â¼ÂºÃ©Â™Â·
04.12.2017	SD-Wrong operationÃ¤Â½ÂœÃ¤Â¸ÂšÃ¥Â¤Â±Ã¨Â¯Â¯
06.12.2017	CM-ContaminationÃ¦ÂÂ‚Ã¨Â´Â¨Ã¥Â¼Â‚Ã§Â‰Â©
06.12.2017	CM-ContaminationÃ¦ÂÂ‚Ã¨Â´Â¨Ã¥Â¼Â‚Ã§Â‰Â©
06.12.2017	QC-process samplingÃ¥Â·Â¥Ã¨Â‰ÂºÃ¥ÂÂ–Ã¦Â Â·
06.12.2017	QC-QC samplingÃ¥Â®ÂžÃ©ÂªÂŒÃ¥ÂÂ–Ã¦Â Â·
06.12.2017	SD-Pinch line damageÃ¥ÂÂˆÃ¦Â¨Â¡Ã§Â¼ÂÃ¥Â¼Â‚Ã¥Â¸Â¸/Ã¥Â‰Â²Ã¤Â¼Â¤

Thanks,

Re: Language Issue

Anil_Babu_Samineni — Thu, 07 Dec 2017 12:05:47 GMT

How is your variable looks like?

SET CollationLocale='en-US';

Re: Language Issue

amit_saini — Thu, 07 Dec 2017 12:11:40 GMT

Yes Actually this report is Global for Europe, America and Asian users.

Only we are having issue when Asian folks specially from China want to see data in Chinese ,other regions are fine with English.

Regards,

Re: Language Issue

amit_saini — Thu, 07 Dec 2017 12:13:35 GMT

It is SET CollationLocale='de-DE'

Even if I changes this to your doesn't make any difference on output.

Regards,

Re: Language Issue

Anil_Babu_Samineni — Thu, 07 Dec 2017 12:30:02 GMT

May be make it as SET CollationLocale='de-zh'

Chinese	zh
Chinese (Simplified)	zh-Hans
Chinese (Traditional)	zh-Hant
Chuvash	cv

Re: Language Issue

amit_saini — Wed, 13 Dec 2017 06:15:14 GMT

Sorry Anil not working.

Regards,

Re: Language Issue

marcus_sommer — Wed, 13 Dec 2017 09:01:57 GMT

Are you sure that the origin chars are really chinese? Make sure of them during the load by checking the chars with ord() maybe with something quite simple like:

...

ord(mid(FIELD, 25, 1) as 25_Char,

...

and then checking the result. A good starting point should be this: cjk - What's the complete range for Chinese characters in Unicode? - Stack Overflow.

Further I think you will need to find a Font which could display these chars - I doubt that most of the common western Fonts will include these chars.

- Marcus