Trimmed column content

[Tommy]

Hello,

I have a table, which has more columns of type NCHAR(X).
If I do a simple select on this table, I get the data, but the content of the columns are trimmed on the right side...only if the value is length like the declaration.....

es:
column type nchar(2), real value 'CF'...result of select: 'C'
column type nchar(7), real value 'gy45jg8'...result of select: 'gy45jg'
column type nchar(9), real value 'valuetest'...result of select: 'valuetes'

ecc ecc....

In sql-plus I get everything as expected.
Is it a known issue?

I use Windows 7 64bit, Oracle 11.2.0.1 and PL/SQL Developer Version 8.0.4.1514

PL/SQL Developer
Version 8.0.4.1514
01.63249 - 1 user license
Windows 7 (64-bit) 6.1 Build 7600

Physical memory : 3,931,428 kB (1,470,984 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (1,900,620 available)

Parameters
C:\Program Files (x86)\PLSQL Developer\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

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

Plug-Ins

Aliases

Homes
OraClient11g_home1 (C:\app\oracle\product\11.2.0\client_1)

DLLs
C:\app\oracle\product\11.2.0\client_1\bin\oci.dll

TNS File
C:\app\oracle\product\11.2.0\client_1\Network\Admin\tnsnames.ora

Using
Home: OraClient11g_home1
DLL: C:\app\oracle\product\11.2.0\client_1\bin\oci.dll
OCI: version 11.1
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0

Character Sets
Character size: 1 byte(s)
CharSetID: 178
NCharSetID: 2000
Unicode Support: True
NLS_LANG: ITALIAN_ITALY.WE8MSWIN1252
NLS_CHARACTERSET: WE8ISO8859P15
NLS_NCHAR_CHARACTERSET: AL16UTF16

 

[Tommy]

uppp...no one had this trouble??

 

[Marco Kalter]

Can you try this patch?

 

[Tommy]

i'll try immediatly...and after i'll let you know something

 

[Tommy]

problem fixed with that version (8.0.4.1520)...

Thanks Marco

 

[Carlo Sirna]

Hi, I am getting into the same problem with DOA (sorry if I do not post this in the doa forum, but I'm just too lazy to describe the same problem described here... especially considered that you already fixed this .

Since I think you actually fixed DOA, and not Pl/sql developer... could you please send me the bugfix to be applied? (you know I use a modified DOA)...

Thank you!

 

[Carlo Sirna]

Of course my former post was for Marco..
Greetings.

 

[Marco Kalter]

Updated DOA sent...