Re: character set problems (umlaut) Oracle8i and Linux

Mysterious.

My database has WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR (I see that these are not identical to yours, but am wondering if there was a small typo in your original post???).

Anyway: I entered the following...

insert into scott.emp (empno, ename, job) values (99, 'Fürtwängle', 'Conductor');

And selected from emp and got...

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTN
O

---------- ---------- --------- ---------- --------- ---------- ---------- -
----
-----
      7369 SMITH      CLERK           7902 17-DEC-80        800
   20
      99 Fürtwängle Conductor

15 rows selected.

Interesting also that my nls_language parameter is apparently set to "American" (that's a new language that I've never heard of before. I thought they spoke English (unless you happen to be President, of course)).

What version of Oracle are you using?, because in 8i you can actually change character sets (in some very limited ways), and that might help.

Otherwise, if your character sets are exactly as you typed them originally, then it's going to be a devil of a job to fix up: character sets can't be changed for earlier versions... so it would be a re-create database job. I hope that umlaut is worth it!

In future, and if disk space is cheap, consider moving to Unicode character sets. Covers all sins.

Regards
HJR "Christoph Panwinkler" <ArbeitsplatzProjektHQDS4_at_voest.co.at> wrote in message news:3A8A9363.176995D4_at_voest.co.at...
> I have created a database with character set WEISO8859P15, but I cannot
> make umlauts and german special characters work.
>
> 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,
> Christoph Panwinkler
Received on Wed Feb 14 2001 - 17:50:21 CST