Re: character set problems (umlaut) Oracle8i and Linux

From: Drazen Kacar <dave_at_arsdigita.com>
Date: Wed, 14 Feb 2001 15:06:10 +0000 (UTC)
Message-ID: <96e6t2$4q6$1@news1.transmedia.de>

Christoph Panwinkler wrote:
> I have created a database with character set WEISO8859P15, but I cannot
> make umlauts and german special characters work.

Unless you're really, really sure you'd never need some other character set, use UTF-8.

> I have also tried to set the environment variable NLS_LANG to
> GERMAN.GERMANY.WEISO8859P15 but when I start the database it does
> complain
> about an unknown NLS_LANG parameter.
> Do I miss anything,

Yes, underscore. And the code page name is slightly different.

prompt> export NLS_LANG=German_Germany.WE8ISO8859P1 or
prompt> export NLS_LANG=German_Germany.WE8ISO8859P15 prompt> sqlplus

SQL*Plus: Release 8.1.6.0.0 - Production on Mi Feb 14 15:58:48 2001

Benutzernamen eingeben:

-- 
 .-.   .-.    Sarcasm is just one more service we offer.
(_  \ /  _)
     |        dave_at_arsdigita.com
     |

Received on Wed Feb 14 2001 - 09:06:10 CST