Bug : Chiness unreadable

[Devilcat]

Odd Chinese characters will be unreadable, even numbers will not

 

[Marco Kalter]

Can you go to Help > Support Info and send me the text from the information page?

 

[Devilcat]

Plyxon
------
Plyxon Version 0.9.1.510 (64 bit)
License: Alpha, Expiration Date: 2024/3/1 (108 days left)

Running Time: 0:00:13

ExePath: C:\Program Files\Plyxon
Documents: C:\Users\miaoc\Documents\Plyxon
Resources: C:\Program Files\Plyxon
Settings: C:\Users\miaoc\AppData\Roaming\Plyxon

Color Theme: Dark

System
------
Windows 11 (Version 23H2, OS Build 22631.2506, 64-bit Edition)
Language ID: China
Scale: 100%
Resolution: 1920 x 1080
Displays: 1
Display 1: 100% 1920 x 1080

Oracle
------
Connected as: sso_qa@kmpex
Server Version: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0

Library: D:\Program Files\ORACLE_client_home\bin\oci.dll
Version: 19.3.0.0.0

TNS File: D:\Program Files\ORACLE_client_home\network\admin\tnsnames.ora
Aliases: kmpex, kmpex1, ORCL, power_new

NLS_LANG: SIMPLIFIED CHINESE_CHINA.ZHS16GBK

 

[Marco Kalter]

Thanks. Can you go to Help > Support Info for PL/SQL Developer as well?

 

[Devilcat]

PL/SQL Developer
Version 15.0.4.2064 (64 bit)
Style: Windows 11 Light
Windows 11 Build 22631
Physical memory : 14,539,512 kB (2,817,212 available)
Paging file : 27,122,424 kB (6,101,892 available)
Virtual memory : 137,438,953,344 kB (137,400,482,464 available)

Parameters
C:\Program Files\PLSQL Developer 15\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: False

Preference Files
C:\Users\miaoc\AppData\Roaming\PLSQL Developer 15\Preferences\default\Default.ini
C:\Users\miaoc\AppData\Roaming\PLSQL Developer 15\Preferences\miaoc\default.ini

License File
C:\ProgramData\PLSQL Developer\aalf.dat

Debug file
C:\Users\miaoc\AppData\Roaming\PLSQL Developer 15\PlSqlDev.elf

Plug-Ins
*Active Query Builder (1.5.0) (C:\Program Files\PLSQL Developer 15\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (1.4.0) (C:\Program Files\PLSQL Developer 15\PlugIns\plsqldoc.dll)
(* is Active)

Aliases
kmpex
kmpex1
ORCL
power_new

Homes

DLLs
D:\Program Files\ORACLE_client_home\bin\oci.dll

TNS File
D:\Program Files\ORACLE_client_home\Network\Admin\tnsnames.ora

Using
Home: D:\Program Files\Oracle\instantclient_21_3
DLL: D:\Program Files\ORACLE_client_home\bin\oci.dll
OCI: version 12.1 (19.3.0.0.0)
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0

Character Sets
Character size: 4 byte(s)
CharSetID: 873
NCharSetID: 2000
Unicode Support: True
NLS_LANG: SIMPLIFIED CHINESE_CHINA.ZHS16GBK
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_CHARACTERSET: AL32UTF8

Process
Working Set = 164,442,112
Memory = 42,329,432
GDI Objects = 728
User Objects = 1068
Handles = 1048

Monitor
PixelsPerInch = 96

Id = 0
PPI = 96
Primary = True
Handle = 65537
Left = 0
Top = 0
Width = 2560
Height = 1440

MainFormOnTaskbar = True

 

[Marco Kalter]

Thanks. One more question: can you go to Preferences > Oracle in Plyxon and let me know the "Character set" from this preference page?

 

[Devilcat]

 

[Devilcat]

A Chinese character occupies 3 bytes. When there are odd Chinese characters, there will be odd bytes. I doubt that there will be problems when there are odd bytes.

 

[Devilcat]

update to Plyxon Version 0.9.4.540

last char is unreadable。

select '啊啊啊' from dual
union all
select '啊啊' from dual
union all
select '啊' from dual;