Language Issue

[amit_saini]

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,

AS 

[YoussefBelloum]

Hi,

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

[amit_saini]

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

Regards,

AS

[YoussefBelloum]

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)

[Anil_Babu_Samineni]

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

[amit_saini]

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,

AS

[Anil_Babu_Samineni]

How is your variable looks like?

SET CollationLocale='en-US';

[amit_saini]

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,

AS

[amit_saini]

It is SET CollationLocale='de-DE'

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

Regards,

AS

[Anil_Babu_Samineni]

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

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