https://community.qlik.com/t5/App-Development/Unable-to-display-Chinese-character-from-Oracle-database-table/m-p/1729784#M55652 <P>Ok I solved this myself. I find out it's because I store the chinese characters as VARCHAR which causes the error. I have to turn it to byte first then turn it to NVARCHAR, which is the only type that handles UTF8 and can be properly shown in the dashboard.<BR /><BR />UTL_RAW.CAST_TO_NVARCHAR2(UTL_RAW.CAST_TO_RAW(&lt;column&gt;))</P> Wed, 22 Jul 2020 06:44:53 GMT JP_KS 2020-07-22T06:44:53Z https://community.qlik.com/t5/App-Development/Unable-to-display-Chinese-character-from-Oracle-database-table/m-p/1729154#M55608 <P>I was trying to display some data from table columns containing Chinese characters, encoded in UTF8, but got some unknown characters instead. I have tried to do CONVERT in SQL and also ApplyCodePage but still displaying some unknown characters. I also tried to display it in byte code which gets System.byte[]. Is there any way to display the data without rebuilding the entire database?</P> Sat, 16 Nov 2024 18:20:34 GMT https://community.qlik.com/t5/App-Development/Unable-to-display-Chinese-character-from-Oracle-database-table/m-p/1729154#M55608 JP_KS 2024-11-16T18:20:34Z https://community.qlik.com/t5/App-Development/Unable-to-display-Chinese-character-from-Oracle-database-table/m-p/1729784#M55652 <P>Ok I solved this myself. I find out it's because I store the chinese characters as VARCHAR which causes the error. I have to turn it to byte first then turn it to NVARCHAR, which is the only type that handles UTF8 and can be properly shown in the dashboard.<BR /><BR />UTL_RAW.CAST_TO_NVARCHAR2(UTL_RAW.CAST_TO_RAW(&lt;column&gt;))</P> Wed, 22 Jul 2020 06:44:53 GMT https://community.qlik.com/t5/App-Development/Unable-to-display-Chinese-character-from-Oracle-database-table/m-p/1729784#M55652 JP_KS 2020-07-22T06:44:53Z