chinese chars display incorrect

[Yeats]

how to fix it

 

[Marco Kalter]

If you set the character set to AL32UTF8, does this affect the issue? Of not, can you send me an example of Chinese text that is not displayed correctly, so that we can try to reproduce this?

 

[Yeats]

If you set the character set to AL32UTF8, does this affect the issue? Of not, can you send me an example of Chinese text that is not displayed correctly, so that we can try to reproduce this?

i've tried utf-8, zhs16gbk and al32utf8, still not helpful at all.

please watch the video attached...
View attachment Video_20240920082711.zip

 

[Marco Kalter]

Can you include the Chinese characters (that are not displayed correctly) as text in a reply?

 

[Yeats]

Can you include the Chinese characters (that are not displayed correctly) as text in a reply?

try this sql

select '你' as tt from dual;
select '你好啊' as tt from dual;

========
i've tried so many times and found that when the length of chinese chars is Odd number, the last chinese char display as '�?'.

 

[Marco Kalter]

This seems to work fine on an AL32UTF8 client and database. Can you let me know your database character set?

 

[Yeats]

database: UTF-8
nls_lang: tried both SIMPLIFIED CHINESE_CHINA.ZHS16GBK and SIMPLIFIED CHINESE_CHINA.AL32UTF8