Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
I found that they suggest to use the (UTF-8) as character set, maybe you should try to do it in your database.
Any change if we can handle this from QlikView side???
Regards,
AS
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)
But few names in english only. Can you attach image / sample data so then we will try in our machine
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
How is your variable looks like?
SET CollationLocale='en-US';
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
It is SET CollationLocale='de-DE'
Even if I changes this to your doesn't make any difference on output.
Regards,
AS
May be make it as SET CollationLocale='de-zh'
Chinese | zh |
Chinese (Simplified) | zh-Hans |
Chinese (Traditional) | zh-Hant |
Chuvash | cv |