German Character - Mulitlingual Application

[Achal Kumar]

We are working with Multilingual Application on a Unicode Oracle Database. SQL Update with German Characters like

 

[Worker]

Under Tools->Preferences->Oracle->Options you will need to check "Unicode enabled".

Under Tools->Preferences->User Interface->Fonts you will need to pick a font that supports the characters you wish to see.

Also, NLS_LANG will need to be set correctly. After connecting to the database, scroll to the bottom of Help->Support Info... to see your current setting.

 

[Achal Kumar]

Under Tools->Preferences->Oracle->Options you will need to check "Unicode enabled".

I don't find a checkbox to set a preference "Unicode enabled" in the above said navigation.

 

[Worker]

What version of PL/SQL Developer are you running? (Help->About)

 

[Achal Kumar]

Version 6.0.3.893

 

[Worker]

In that case I'll have to defer to the experts at Allround support for the answer to your question. Unfortunately I don't know in what ways (if any) PL/SQL Developer 6.0 supports Unicode.

 

[Marco Kalter]

For Unicode support you will need to upgrade to 7.0.3 or later. Version 6.0.3 does not support Unicode.

 

[BlackVX]

I'm having a similar issue with V8. I see reverse "?" when performing a select in the SQL Window. A co-worker of mine still use the version 7.000150 and it works fine for the same select.

I enabled the Unicode option and tried with Arial and Verdana. The special characters I'm trying to view are from Microsoft Word (examples:

 

[BlackVX]

Oh and here is the Support info at the bottom of the popup window.

Character Sets
Character size: 1 byte(s)
CharSetID: 31
NCharSetID: 2000
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.WE8MSWIN1252
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_CHARACTERSET: WE8ISO8859P1

 

[BlackVX]

Marco replied to my email and found the solution for my case. This is just for future reference in case someone hit the same issue.

------------
A reversed question mark indicates that the Oracle character set (client or server) cannot represent the character in question, in this case the soft hyphen. It seems to me that the database charater set WE8ISO8859P1 is the culprit here. The client character set WE8MSWIN1252 does support the soft hyphen.
If you have any additional questions, just let me know.
Greetings,
Marco Kalter
------------

So I went in my desktop registry and change the character set from WE8ISO8859P1 to WE8MSWIN1252 and I could see the special characters correctly in Pl/SQL Developer.

Thanks