Thank you very much for the hint. The problem occurs on SuSE linux, though,
not on FreeBSD, and lang=de_DE.
Following your hint, I set
LANG=de_DE.ISO_8859-1
The problem still remains. Then I set
LANG=de
since there is a directory
/usr/share/locale/de
on the system, but not /usr/share/locale/de_DE
Still, no luck.
Any more ideas how to solve this problem are warmly welcome.
s.m.
Am Mittwoch, 20. März 2002 15:57 schrieb Ken Menzel:
> Regarding your issue with accents, I understand more now about your
> problem, you are using shell tools in free BSD and you have not set
> the LANG shell environment variable. Add the folling line to your
> shell environments (usually .profile).
> LANG=en_US.ISO_8859-1; export LANG
>
> or for german language shell messaging:
> LANG=de_DE.ISO_8859-1; export LANG
>
> This is a FreeBSD issue, by default LINUX sets the language
> environment for the shell to an ISO setting, FreeBSD does not.
>
> Ken
> ----- Original Message -----
> From: "sascha mantscheff" <[EMAIL PROTECTED]>
> To: "Harald Fuchs" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Wednesday, March 20, 2002 5:52 AM
> Subject: Re: still no umlauts in mysql --experts help needed
>
> > Am Mittwoch, 20. März 2002 11:24 schrieben Sie:
> > > > I just installed mysql fresh out of the box on a fresh SuSE
>
> linux 7.1.
>
> > > > mysql does not let me enter german umlauts, though. I tried to
>
> start it
>
> > > > with "mysql --default-character-set=latin_de", but it complained
>
> about
>
> > > > the character sets not being installed. Then I installed the
>
> mysql
>
> > > > server, which in turn installs the character sets. latin_de is
>
> not
>
> > > > included, though. I tried it with
>
> "mysql --default-character-set=german1"
>
> > > > instead. No luck.
> > >
> > > Was meinst Du mit "does not let me enter"? Blockieren die
> > > entsprechenden Tasten? Erscheint nichts auf dem Bildschirm? Gibt
>
> es
>
> > > irgendeine Fehlermeldung? Liefert MySQL bei einem SELECT das
>
> Falsche
>
> > > zurück?
> >
> > keystrokes with umlauts do not have any echo on the screen. batch
>
> input (text
>
> > files with sql statements with umlauts redirected to mysql) do not
>
> insert
>
> > umlauts into the database (but the rest of the text, so that the
>
> words are
>
> > mis-spelt). there is no error message. select statements contain any
>
> umlauts
>
> > in the database, though, and I can enter umlauts into the database
>
> using
>
> > other clients than mysql.
> >
> > s.m.
> >
> > --------------------------------------------------------------------
>
> -
>
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
>
> <[EMAIL PROTECTED]>
>
> > Trouble unsubscribing? Try:
>
> http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
