Hi Sasha, Ooops ok, LANG is for FreeBSD. I misunderstood. I don't know SuSE Linux but on my Mandrake Linux system I have this: [ken@nx01 ken]$ set | grep -i lang LANG=en LANGUAGE=en_US:en RPM_INSTALL_LANG=en_US:en langfile=/etc/sysconfig/i18n
I am not sure how this works (I prefer freeBSD). What is setup in your shell on SuSE? Do the accented characters work OK at the $ shell prompt and vi, just not in mysql? Maybe a SuSE Linux expert can comment. Hope this helps, Ken ----- Original Message ----- From: "sascha mantscheff" <[EMAIL PROTECTED]> To: "Ken Menzel" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 1:21 PM Subject: Re: still no umlauts in mysql --experts help needed > 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
