Displayng Japanese in PL/SQL 7.0.1.1066 01.36120

[Naeem]

I am using PL/SQL 7.0.1.1066 01.36120. I am trying to save Japanese characters but these are converted into ???????. Following are my settings.

User - NLS Session Parameters
Parameter Value
NLS_CALENDAR GREGORIAN
NLS_COMP BINARY
NLS_CURRENCY ¥
NLS_DATE_FORMAT RR-MM-DD
NLS_DATE_LANGUAGE JAPANESE
NLS_DUAL_CURRENCY \
NLS_ISO_CURRENCY JAPAN
NLS_LANGUAGE JAPANESE
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NUMERIC_CHARACTERS .,
NLS_SORT BINARY
NLS_TERRITORY JAPAN
NLS_TIMESTAMP_FORMAT RR-MM-DD HH24:MI:SSXFF
NLS_TIMESTAMP_TZ_FORMAT RR-MM-DD HH24:MI:SSXFF TZR
NLS_TIME_FORMAT HH24:MI:SSXFF
NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZR

Please help.
Naeem

 

[Claus Pedersen]

I am not an expert in Japanese characters, but I believe that the length semantics should be CHAR in order to store 2-byte characters in the database.

 

[gulhaugen]

Actually, I do not think length semantics has anything to do with, it just tells Oracle how do deal with lengths (ie max length, and length of '

 

[Marco Kalter]

What is the character set of the NLS_LANG key of your primary oracle home? The problem indicates that Oracle Net cannot convert the characters from the server to a client-side representation, ans replaces them with question marks.

 

[Naeem]

Thanks Claus Pedersen, gulhaugen and Marco Kalter for replying. I have tried ODP.NET, did not worked for me. I dont have visual studio installed on my machine.

Marko, NLS_LANG=Japanese_Japan.UTF8.

I have even changed my regional settings to Japanese. It would be helpful if I find a solution by using PL/SQL Dev.

Thanks Naeem

 

[Marco Kalter]

I see now that you are using 7.0.1, which does not support Unicode . Just upgrade to 7.0.3 or later to fix this.

 

[Naeem]

Thanks Marco Kalter,

I have downloaded PL/SQL 7.1.4 trial version. It worked. I am now planning to buy this latest version.