NLS problem with v. 8 and Win 7 x64

[Stephan B.]

Hi,

i have installed the version 8 under a german Windows 7 x64. While selecting names with umlauts out of my database i can't get any correct characters like 'B

 

[Marco Kalter]

The NLS settings look okay to support umlauts or any other German character. To check if this is an Oracle Client issue, can you go to Tools > Preferences > Oracle / Connection, select "OraClient10g_home1" from the Oracle Home selection list, restart PL/SQL Developer, and try again?

If this also fails then maybe this is an application font/character set issue. We would need to verify the font preference settings.

 

[Stephan B.]

I can't login with the selection "OraClient10g_home1' because i get a empty messagebox.

Any other ideas

 

[Marco Kalter]

Can you enter umlauts when editing record data? If so, how is it returned when you fetch the edited record again?

 

[Stephan B.]

Hello Marco,

no problem:

create table umlauttest (umlaute varchar2(10))
insert into umlauttest values ('

 

[Marco Kalter]

Can you run the same query in the Command Window?

 

[Stephan B.]

I don't think, that is a "visual" problem.

Here the same table selected with the oracle-developer...

 

[6502]

I have checked my registry. All entries are correct with german as language.

Hi,

May I ask which entries in the registry? This one too? HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient11g_home1\NLS_LANG

The SQL-Developer is able to work without a client, then using the windows default charset. Did you use the direct connection type? Does the SQL-Developer show the Umlauts when using tns-connection?

Regards
Cornel

 

[Stephan B.]

Hi,

the value there is GERMAN_GERMANY.WE8MSWIN1252.

Is this a bug? Anyone outside there running PL/SQL-Developer under W7/x64?

 

[Stephan B.]

come on, there should be a solution, workaround or something else...

 

[Marco Kalter]

I think we have looked at everything. Can you try this with any other Oracle Client tool other than Oracle SQL Developer (which does not use the Oracle Client)?