Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Trouble with Codepage/Language settings AKA German Umlaute

xxxx dfsdfsdApr 29 2023

I am trying to access a 3rd party Oracle Datebase which basically works fine except for grabage with german Umlaute:

I tried GERMAN_GERMANY.WE8MSWIN1252 - no success.

Now I tried different queries and I get different answers:

SELECT * FROM NLS_DATABASE_PARAMETERS;

returns AMERICAN/AMERICA WE8MSWIN1252

Same for SELECT * FROM NLS_INSTANCE_PARAMETERS;

return GERMAN/GERMANY and no Codepage

SELECT * FROM V$NLS_PARAMETERS; returns the same but on top NLS_CHARACTERSET

WHat is my correct setting for the driver?

Added on Apr 29 2023

3 comments

328 views