Re: character set problems (umlaut) Oracle8i and Linux

I don't think any Englishman will recognize the lingo spoken in the US as 'English'.
(Refer amongst others to the musical 'My Fair Lady') Oracle seems to recognize this, as does Microsoft. Your variant of the English has been termed American by Oracle since the early days of Oracle v6.
Just for the record, your conductor is missing the last r in his surname.

Lol

Regards,

Sybrand Bakker, Oracle DBA

"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:sXEi6.204$305.67552_at_inet16.us.oracle.com...
> 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 Sat Feb 17 2001 - 12:29:11 CST