Re: character set problems (umlaut) Oracle8i and Linux

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:t8tse6ng4t4aed_at_beta-news.demon.nl...
> I don't think any Englishman will recognize the lingo spoken in the US as
> 'English'.

I think we can cope. One must, of course, show tolerance for our colonial cousins. ;-)

> (Refer amongst others to the musical 'My Fair Lady')

Do I have to? :-(

> Oracle seems to recognize this, as does Microsoft.

Mmmmm. American companies both. What does that tell you?

> Your variant of the English has been termed American by Oracle since the
> early days of Oracle v6.

Which just goes to prove that Hitler was right: if you're going to tell a lie, make it a biggie, and keep at it until everyone believes it.

> Just for the record, your conductor is missing the last r in his surname.

Yup, I realise! You may recall, however, that Scott created his EMP table with the ENAME field set to varchar2(10). Perhaps I should have picked Böhm?

>
> Lol

Me too.... Cheers
HJR
>
> 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 - 17:08:19 CST