Viewing Results in SQL Window

[mani]

This is to do with viewing results of select statments in SQL Window:
I'm facing a problem whereby I'm not able to view data in all columns which are of type nvarchar2. But this problem happens only when I connect to a specific oracle host. It doesn't happen with other oracle hosts. And the surprising thing is that it happens only in my PLSQL Developer client. It works fine in other clients??

 

[Marco Kalter]

Perhaps you are using an old Oracle Net version on the PL/SQL Developer client where this fails?

------------------
Marco Kalter
Allround Automations

 

[mani]

But the funny thing it was working fine initially and only later I started facing this problem.
If it is to do with the Net service version of Oracle, how come I don't face this issue when connecting to other Oracle hosts?

 

[Marco Kalter]

I forgot to ask what the exact problem is? Is there an error message? Is the data incorrect?

------------------
Marco Kalter
Allround Automations

 

[Eric Mowrer]

I have the exact same symptoms. I simply cannot see any cells that contain nvarchar2 data. They are blank. There are no error messages and everything works fine, otherwise.

 

[Marco Kalter]

What is your Oracle Client and Server version, and your PL/SQL Developer version?

 

[Eric Mowrer]

The following from PL/SQL Developer about screen:
-------------
OCI: Version 8.1
DLL: c:\oracle\ora81\bin\oci.dll
Oracle 9i Enterprise Edition Release 9.2.0.3.0

PL/SQL Developer
Version 5.1.4.730 01.18163
--------------

The DB to which I am connecting is 9.2.0.4

 

[Marco Kalter]

Do you also have an Oracle 9.2 client to verify this issue? It seems that you are now using an 8i client on a 9.2 server.

 

[Eric Mowrer]

Ok, I installed an oracle 9.2 client. I can see data for nvarchar2 columns now, but it isn't showing anything above extended ascii correctly. I'll chew on that for a while. I know it's correct in the database. Do I need to set something on my oracle client or something in PS/SQL Developer?

 

[Marco Kalter]

The character set of the grid font (Tools > Preferences > Fonts tab page) must be compatible with the characters you are trying to view.