Print Thread
Bug : Chiness unreadable
#65043 11/13/23 12:15 PM
Joined: Nov 2023
Posts: 6
D
Member
OP Offline
Member
D
Joined: Nov 2023
Posts: 6
[Linked Image]
Odd Chinese characters will be unreadable, even numbers will not

Attached Files
微信图片编辑_20231113202135.jpg (12.6 KB, 167 downloads)
微信图片编辑_20231113202546.jpg (16.6 KB, 76 downloads)
Last edited by Devilcat; 11/13/23 12:35 PM.
Re: Bug : Chiness unreadable
Devilcat #65045 11/14/23 09:42 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
Can you go to Help > Support Info and send me the text from the information page?


Marco Kalter
Allround Automations
Re: Bug : Chiness unreadable
Devilcat #65049 11/14/23 01:22 PM
Joined: Nov 2023
Posts: 6
D
Member
OP Offline
Member
D
Joined: Nov 2023
Posts: 6
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

Re: Bug : Chiness unreadable
Devilcat #65053 11/14/23 01:56 PM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
Thanks. Can you go to Help > Support Info for PL/SQL Developer as well?


Marco Kalter
Allround Automations
Re: Bug : Chiness unreadable
Devilcat #65056 11/14/23 06:23 PM
Joined: Nov 2023
Posts: 6
D
Member
OP Offline
Member
D
Joined: Nov 2023
Posts: 6
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: <none>
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

Re: Bug : Chiness unreadable
Devilcat #65058 11/15/23 09:21 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
Thanks. One more question: can you go to Preferences > Oracle in Plyxon and let me know the "Character set" from this preference page?


Marco Kalter
Allround Automations
Re: Bug : Chiness unreadable
Devilcat #65059 11/15/23 09:27 AM
Joined: Nov 2023
Posts: 6
D
Member
OP Offline
Member
D
Joined: Nov 2023
Posts: 6
[Linked Image]

Attached Files
微信图片编辑_20231115172447.jpg (61.65 KB, 81 downloads)
Re: Bug : Chiness unreadable
Devilcat #65061 11/15/23 09:35 AM
Joined: Nov 2023
Posts: 6
D
Member
OP Offline
Member
D
Joined: Nov 2023
Posts: 6
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.

Last edited by Devilcat; 11/15/23 09:36 AM.
Re: Bug : Chiness unreadable
Devilcat #65186 12/11/23 06:54 AM
Joined: Nov 2023
Posts: 6
D
Member
OP Offline
Member
D
Joined: Nov 2023
Posts: 6
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;

Attached Files
微信图片_20231211145114.png (13.11 KB, 16 downloads)
Last edited by Devilcat; 12/11/23 06:55 AM.

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.028s Queries: 17 (0.007s) Memory: 2.5419 MB (Peak: 3.0428 MB) Data Comp: Off Server Time: 2024-05-20 05:32:15 UTC
Valid HTML 5 and Valid CSS