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