SQL & PL/SQL

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!

Character conversion ... struggling with funny characters

xxxx dfsdfsdNov 2 2023

Since a longer time, I am having trouble with a database on a server.

I always get wrong results with queries regarding german Umlaute and other special characters.

NLS-characterset is always WE8MSWIN1252
NLS_NCHAR_CHARACTERSET is AL16UTF16

This applies to V$NLS_PARAMETERS, DATABASE_PARAMETERS. SESSION and INSTANCE_PARAMETERS do not return information about chractersets

Using Oracle SQL Developer (on a client computer), a typical select on a table with names returns for instance a ‘" ’(right double quote) instead of an ‘ö’ (german umlaut oe.

or now nothing helped …

… setting the encoding parameter in oracledb (which is a python modul)

… Using a computed column in my select CONVERT(name_col, ‘WE8MSWIN1252’). At least changing the parameter can change the garbage returned. Mostly, the ‘ö’ results in an inverted question mark

What can I do? Where is my mistake?

Added on Nov 2 2023

6 comments

539 views