Character confusion

From: Marcel Stör <marcel>
Date: Thu, 4 Sep 2003 17:04:28 +0200
Message-ID: <3f57547c$0$240$4d4ef98e@read.news.ch.uu.net>

My environment is RedHat and 9i. If I enter German umlauts into a table through a GUI tool like DBAStudio and retrieve the same values with DBAStudio everything seems to be ok. However, if I query the same table from console with SQLPlus the umlauts are no umlauts anymore (ü turns to u, ö turns to o).

So I checked v$nls_parameters of the session: NLS_CHARACTERSET is WE8ISO8859P1
NLS_NCHAR_CHARACTERSET is AL16UTF8
with AMERICAN/AMERICA

I just doesn't look right...

So I also checked sys.props$. As expected it returns the same values.

Linux' $LANG environment parameter is de_CH.UTF-8.

I'm stuck with all those locale's and charactersets. I also changed the Linux locale to en_US.UTF-8, which - as expected - has no influence on the umlaut behaviour. Not surprisingly, a CGI web app running on Oracle returns the umlauts like they appear on the console.

I would realy appreciate if you could tell me how to sync all those settings.

Best regards,
Marcel Received on Thu Sep 04 2003 - 10:04:28 CDT