Problem with German Umlaute

[Simon Martinelli]

I can set the whatever encoding (ANSI or UTF-8) if I set a Umlaut (for example ü) and compile the package and then reopen the package I see a question mark.

If I edit the package in another tool the Umlaut looks ok.

 

[Simon Martinelli]

I found another thread about this problem and now I set

NLS_LANG=german_switzerland.we8iso8859p1

and it works.

Question: why do I have to set this in PL/SQL Developer?

 

[Marco Kalter]

PL/SQL Developer uses the NLS_LANG that is defined for your Oracle Client configuration. If there is no NLS_LANG defined, it will issue a warning.

 

[fro]

Hi, where i have to set the NLS_LANG paramter? Windows User Envirement?
Thanx

 

[Marco Kalter]

You can set it as an Environment Variable on the PC (User or System Variable), or if you are using PL/SQL Developer 15, you can go to Preferences > Oracle > Connection and add it to the "Oracle Environment Variables" list.

 

[fro]

Hi Marko,
tried everything, I'm done
User environment NLS_LANG=GERMAN_GERMANY,

PLSQL Dev Info:

Character Sets
Character size: 4 byte(s)
CharSetID: 0
NCharSetID: 873
Unicode Support: False
NLS_LANG: GERMAN_GERMANY.UTF8
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_CHARACTERSET: AL32UTF8

I do not know what to do. The output in the grid in the SQL window is still normal. But if I export the result, then the umlauts become a problem. Likewise if I write via dbms_output in a command_window, example:

l_strg := '-- Änderung am : $Date: $';
dbms_output.put_line(l_strg);
output result:

-- Änderung am : $Date: $

We generate all rollouts of inserts, updates, etc. in scripts that I have to check again and again. That's annoying. I've never had a problem with it in 20 years, but with version 14.0.6.1988 I just can't get it to work.
Thank you for helping.
Roland

 

[Marco Kalter]

Can you send me such an export example file?