nvarchar columns not displaying correctly

[Robert Yarbrough]

When selecting from a nvarchar2 column, pl/sql developer will not show the full number of characters the column is supposed to be able to hold.

For instance, if I make a table called dummy with a column dummy1 of type nvarchar2(10) then insert a value 1234567890 When I select this row, pl/sql developer will display 123456789 instead of 1234567890.

This happened after upgrading our Oracle client from 10 to 11. Has anyone else seen this, or have an idea for a workaround?

Thanks!

 

[Marco Kalter]

Can you go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[Robert Yarbrough]

I emailed this thread along with the requested information to support@allroundautomations.com

 

[Cyrill]

Hi all
What was the solution for this?
to_char() works
doesn't display all characters
Sqlplus works as expected.
thanks and regards
Cyrill

 

[Marco Kalter]

This is fixed in the current 9.0 version.