Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Character confusion
Marcel Stör wrote:
> 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).
From the linux shell, try:
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
or:
export NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1
before executing the sqlplus binary.
HTH
-- Cris Carampa (spamto:cris119_at_operamail.com) [Per fare il lavoro di giudice] "devi essere mentalmente disturbato, devi avere delle turbe psichiche. Se fanno quel lavoro č perché sono antropologicamente diversi dal resto della razza umana." (S. Berlusconi)Received on Thu Sep 04 2003 - 10:10:24 CDT