Hi,
we are encountering the following issue after migrating our source files to UTF‑8 encoding.
As part of this migration, we set the NLS_LANG environment variable to .AL32UTF8. However, the Oracle databases we connect to are still using the WE8MSWIN1252 character set.
PL/SQL Developer appears to handle the input correctly in this configuration: SQL statements written in UTF-8 are properly converted to WE8MSWIN1252 when sent to the database. We do not see any issues here here with the SQL that is received by the database.
The problem occurs with the output shown by PL/SQL Developer. When executing these files or interactively input these SQL commands in either the SQL Window or the Command Window, the output is truncated. Parts of the expected output seem to be missing, as if characters were being swallowed or cut off during display.
I have attached screenshots that show the SQL input and resulting output in both the SQL Window and the Command Window.
Additionally, please find the PL/SQL Developer Support Info output attached below:
Is this a known issue?
Kind regards,
Nico
we are encountering the following issue after migrating our source files to UTF‑8 encoding.
As part of this migration, we set the NLS_LANG environment variable to .AL32UTF8. However, the Oracle databases we connect to are still using the WE8MSWIN1252 character set.
PL/SQL Developer appears to handle the input correctly in this configuration: SQL statements written in UTF-8 are properly converted to WE8MSWIN1252 when sent to the database. We do not see any issues here here with the SQL that is received by the database.
The problem occurs with the output shown by PL/SQL Developer. When executing these files or interactively input these SQL commands in either the SQL Window or the Command Window, the output is truncated. Parts of the expected output seem to be missing, as if characters were being swallowed or cut off during display.
I have attached screenshots that show the SQL input and resulting output in both the SQL Window and the Command Window.
Additionally, please find the PL/SQL Developer Support Info output attached below:
Code:
PL/SQL Developer
Version 16.0.8.2176 (64 bit)
01.154269 - Unlimited user license
Service Contract: 01.05.2023
Style: Sky
Windows 10 Build 17763
en-US(1033)/English (United States)
Physical memory : 201.326.068 kB (180.196.900 available)
Paging file : 220.916.208 kB (192.989.248 available)
Virtual memory : 137.438.953.344 kB (137.433.951.208 available)
Parameters
C:\Program Files\PLSQL Developer 16\plsqldev.exe
nosplash
prefpath=Z:\tmp\blub
Preferences
Session mode: Multi
OCI Library: <none>
Use OCI7: False
Allow Multiple Connections: True
Preference Files
\\siv-cluster01-svm-cifs01.siv.de\TSProfile\Userdata\n\AppData\Roaming\PLSQL Developer 16\Preferences\default\Default.ini
Z:\tmp\blub\n\default.ini
License File
C:\ProgramData\PLSQL Developer\aalf.dat
Debug file
\\siv-cluster01-svm-cifs01.siv.de\TSProfile\Userdata\n\AppData\Roaming\PLSQL Developer 16\plsqldev.log
Plug-Ins
*Active Query Builder (1.5.1) (C:\Program Files\PLSQL Developer 16\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (1.4.1) (C:\Program Files\PLSQL Developer 16\PlugIns\plsqldoc.dll)
(* is Active)
Enabled AI Systems
OpenAI GPT
Aliases
Homes
OH1939595010 (D:\app\oracle\Middleware\frt11g\frhome)
OH416195435 (D:\app\oracle\Middleware\frt11g\oracle_common)
OraClient19Home1 (D:\devtools\Oracle\product\19.0.0\client_1)
DLLs
D:\devtools\Oracle\product\19.0.0\client_1\bin\oci.dll
TNS File
D:\devtools\tns_admin\tnsnames.ora
Using
Home: <Instant Client>
DLL: D:\devtools\instantclient_23_0\oci.dll
OCI: version 12.1 (23.26.0.0.0)
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
Character Sets
Character size: 1 byte(s)
CharSetID: 873
NCharSetID: 2000
Unicode Support: True
NLS_LANG: .AL32UTF8
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_CHARACTERSET: WE8MSWIN1252
Process
Working Set = 165.765.120
Memory = 40.319.424
GDI Objects = 632
User Objects = 409
Handles = 752
Monitor
PixelsPerInch = 96
Id = 0
PPI = 96
Primary = True
Handle = 65537
Left = 0
Top = 0
Width = 3838
Height = 2079
MainFormOnTaskbar = TrueIs this a known issue?
Kind regards,
Nico
