Foreign language query

[sks]

Hi,

We are PL/SQL Developer user's. we are stuck into an issue, where we are trying to insert, update some foreign character's (non english) into database, but are not able to do so. The tool insert's and show's inverted question mark.

Our database supports foreign language since we can do this from SQL Developer. Also in PL/SQL Developer we have tried with enabling and disabling the unicode option. Please suggest how can we work with foreign language data in PL/SQL developer.

Warm Regards,
sks

 

[sks]

Hi... please suggest..

 

[Marco Kalter]

Inverted question marks imply a character set conversion compatibility issue. The character set of the NLS_LANG setting on the client is most likely incompatible with the database character set. Modify the NLS_LANG on the client to resolve this.

 

[sks]

Thanks for the reply..
Can you please tell where can we set NLS_LANG in PL/SQL Developer..?

Regards

 

[Marco Kalter]

You can set it in the Oracle Registry:

hkey_local_machine\software\oracle\key_\nls_lang