I'm unable to view text data stored in a database with UTFcharacter set.
for example,
I have entered some japanese characters and this is to be saved in the UTF oracle database.
I am using PL/SQL developer to access the database to verify the japanese entry which i've made. However, i am unable to view the appropriate japanese characters despite making the font changes in the Tools -> Preferences -> Fonts option in PL/SQL to set the fonts suitable for viewing japanese characters.

The NLS_LANG registry parameter for my oracle8i is AMERCIAN_AMERICA.WE8ISO8859P1.

My database parameters is as below :-

NLS Database Parameters
Parameter Value
NLS_CALENDAR GREGORIAN
NLS_CHARACTERSET UTF8
NLS_COMP BINARY
NLS_CURRENCY $
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_DUAL_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_LANGUAGE AMERICAN
NLS_NCHAR_CHARACTERSET UTF8
NLS_NUMERIC_CHARACTERS .,
NLS_RDBMS_VERSION 8.1.7.0.0
NLS_SORT BINARY
NLS_TERRITORY AMERICA
NLS_TIMESTAMP_FORMAT
NLS_TIMESTAMP_TZ_FORMAT
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM

Can someone help me to view japanese/other languages successfully in an UTF database via PL/SQL?

Many Thanks,
Shean Yang

The NLS_LANG setting of your Oracle Home registry must include the appropriate Japanese character set. If it is WE8ISO8859P1, all characters will be converted to 8 bits west european.

Can you change this and try again?

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