Displaying nvarchar2 columns

[golouhm]

We have a table with both varchar2 and nvarchar2 columns. Using java frontend we can sucessfuly select, insert and update nvarchar2 columns. But when doing a select on this table from pl/sql developer SQL window we get giberihs in nvarchar2 columns.

Characterset for nvarchar2 is AL16UTF16 and we are using PL/SQL Developer 6.0.4.906.

 

[Marco Kalter]

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

 

[golouhm]

Guess it was a configuration problem. Doing copy/paste of Support info I noticed that Oracle 8i home was listed first. I changed to 9i home and now it works.

Thanx

 

[Marco Kalter]

Okay, thanks.