Forums Active Threads
Print Thread
chinese chars display incorrect
#65868 09/19/24 02:14 AM
Joined: Mar 2012
Posts: 27
Y
Yeats Offline OP
Member
OP Offline
Yeats
Member
Y
Joined: Mar 2012
Posts: 27
how to fix it

Attached Files
QQ20240919-101151.png (76.89 KB, 42 downloads)
Re: chinese chars display incorrect
Yeats #65869 09/19/24 08:28 AM
Joined: Aug 1999
Posts: 22,487
Marco Kalter Offline
Member
Offline
Marco Kalter
Member
Joined: Aug 1999
Posts: 22,487
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?

Marco Kalter
Allround Automations
Re: chinese chars display incorrect
Marco Kalter #65877 09/20/24 12:33 AM
Joined: Mar 2012
Posts: 27
Y
Yeats Offline OP
Member
OP Offline
Yeats
Member
Y
Joined: Mar 2012
Posts: 27
Originally Posted by 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?

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

please watch the video attached...

Attached Files
Video_20240920082711.zip (214.71 KB, 1 downloads)
SHA1: 8b6737947e758881139f7546f9e30e65c3e68056
Re: chinese chars display incorrect
Yeats #65883 09/20/24 09:05 AM
Joined: Aug 1999
Posts: 22,487
Marco Kalter Offline
Member
Offline
Marco Kalter
Member
Joined: Aug 1999
Posts: 22,487
Can you include the Chinese characters (that are not displayed correctly) as text in a reply?

Marco Kalter
Allround Automations
Re: chinese chars display incorrect
Marco Kalter #65886 09/20/24 09:21 AM
Joined: Mar 2012
Posts: 27
Y
Yeats Offline OP
Member
OP Offline
Yeats
Member
Y
Joined: Mar 2012
Posts: 27
Originally Posted by Marco Kalter
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 '�?'.

Last edited by Yeats; 09/20/24 09:28 AM.
Re: chinese chars display incorrect
Yeats #65896 09/20/24 02:48 PM
Joined: Aug 1999
Posts: 22,487
Marco Kalter Offline
Member
Offline
Marco Kalter
Member
Joined: Aug 1999
Posts: 22,487
This seems to work fine on an AL32UTF8 client and database. Can you let me know your database character set?

Marco Kalter
Allround Automations
Re: chinese chars display incorrect
Yeats #65900 09/23/24 02:04 AM
Joined: Mar 2012
Posts: 27
Y
Yeats Offline OP
Member
OP Offline
Yeats
Member
Y
Joined: Mar 2012
Posts: 27
database: UTF-8
nls_lang: tried both SIMPLIFIED CHINESE_CHINA.ZHS16GBK and SIMPLIFIED CHINESE_CHINA.AL32UTF8

Link Copied to Clipboard
Privacy Policy · Forum Rules · Mark All Read Contact Us · Forum Help ·
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.034s Queries: 16 (0.007s) Memory: 2.5212 MB (Peak: 3.0397 MB) Data Comp: Off Server Time: 2024-12-04 06:25:20 UTC
Valid HTML 5 and Valid CSS