View Chinese data

[Jignesh Joshi]

Hi:
I am using Pl/SQL developer 5.0.3.527.

I have some Chinese data stored in the database. My database character set is UTF8.

My windows NLS_LANG is set to AMERICAN_AMERICA.ZHT16NIG5.

I changed all the fonts in the preference section to Ming Liu to view the Chinese data but still the data appears as "????".

Can you please tell me how can view chinese data in the database ?

Thanks.

 

[Marco Kalter]

It may be necessary to upgrade to 5.1. You could test this by downloading and installing the 5.1 trial version .

If all character sets, languages, and fonts are set correctly, this should work.

 

[Jignesh Joshi]

Thanks Marco for the response.

I upgraded to 5.1.5.744.

I have windows NLS_LANG = AMERICAN_AMERICA.UTF8.

I have set all Fonts in PL/SQL developer to MingLiu and SCript to CHINESE_BIG5.

Now I am able to see chinese character but all the values show the same character which is not correct. I can see correct data using my web application.

What am I not doing right ? Have I missed anything ? Please let me know.

Thanks.

- Jignesh

 

[Marco Kalter]

The character set of the NLS_LANG setting on the client must match the character set of the font preference in PL/SQL Developer.