Re: still no umlauts in mysql --experts help needed
Am Freitag, 22. März 2002 11:58 schrieben Sie:
> > Egor:
> > Thanks for the hint. I browsed the manual for readline(3) and for
> > /etc/inputrc, but found nothing wrong with it. I can enter umlauts in all
> > other programs and from the bash command-line - only in mysql they don't
> > work. Where else might I look for the source of the problem?
>
> Schreib doch mal sowas wie
>
> INSERT INTO test (t) VALUES ("ÄÖÜäüß");
>
> in eine Datei und ruf dann
>
> mysql test < datei
>
> auf. Was passiert dann?
It works -- I'm sure I tested it already with negative results, but now it
works. [So much for being sure.] So I can enter umlauts with a file
redirection, but not directly in the mysql client. This is good enough for a
work-around, but still I'd really like to fix this problem at it's source.
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
Re: still no umlauts in mysql --experts help needed
Egor: Thanks for the hint. I browsed the manual for readline(3) and for /etc/inputrc, but found nothing wrong with it. I can enter umlauts in all other programs and from the bash command-line - only in mysql they don't work. Where else might I look for the source of the problem? s.m. Am Donnerstag, 21. März 2002 16:44 schrieben Sie: > sascha, > Wednesday, March 20, 2002, 12:52:41 PM, you wrote: > > sm> Am Mittwoch, 20. März 2002 11:24 schrieben Sie: > sm> > I just installed mysql fresh out of the box on a fresh SuSE linux > 7.1. sm> > mysql does not let me enter german umlauts, though. I tried to > start it sm> > with "mysql --default-character-set=latin_de", but it > complained about sm> > the character sets not being installed. Then I > installed the mysql sm> > server, which in turn installs the character > sets. latin_de is not sm> > included, though. I tried it with "mysql > --default-character-set=german1" sm> > instead. No luck. > sm> > sm> Was meinst Du mit "does not let me enter"? Blockieren die > sm> entsprechenden Tasten? Erscheint nichts auf dem Bildschirm? Gibt es > sm> irgendeine Fehlermeldung? Liefert MySQL bei einem SELECT das Falsche > sm> zurück? > > sm> keystrokes with umlauts do not have any echo on the screen. batch input > (text sm> files with sql statements with umlauts redirected to mysql) do > not insert sm> umlauts into the database (but the rest of the text, so that > the words are sm> mis-spelt). there is no error message. select statements > contain any umlauts sm> in the database, though, and I can enter umlauts > into the database using sm> other clients than mysql. > > Looks like it's a question of readline/local, it's not a MySQL > problem. > > sm> 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
Re: still no umlauts in mysql --experts help needed
sascha, Wednesday, March 20, 2002, 12:52:41 PM, you wrote: sm> Am Mittwoch, 20. März 2002 11:24 schrieben Sie: sm> > I just installed mysql fresh out of the box on a fresh SuSE linux 7.1. sm> > mysql does not let me enter german umlauts, though. I tried to start it sm> > with "mysql --default-character-set=latin_de", but it complained about sm> > the character sets not being installed. Then I installed the mysql sm> > server, which in turn installs the character sets. latin_de is not sm> > included, though. I tried it with "mysql --default-character-set=german1" sm> > instead. No luck. sm> sm> Was meinst Du mit "does not let me enter"? Blockieren die sm> entsprechenden Tasten? Erscheint nichts auf dem Bildschirm? Gibt es sm> irgendeine Fehlermeldung? Liefert MySQL bei einem SELECT das Falsche sm> zurück? sm> keystrokes with umlauts do not have any echo on the screen. batch input (text sm> files with sql statements with umlauts redirected to mysql) do not insert sm> umlauts into the database (but the rest of the text, so that the words are sm> mis-spelt). there is no error message. select statements contain any umlauts sm> in the database, though, and I can enter umlauts into the database using sm> other clients than mysql. Looks like it's a question of readline/local, it's not a MySQL problem. sm> s.m. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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
Re: still no umlauts in mysql --experts help needed
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
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
Re: still no umlauts in mysql --experts help needed
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
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
still no umlauts in mysql --experts help needed
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. This is not a general problem of my system's configuration. Umlauts work from the console, in xterm and konsole and all other editors and programs - except mysql. Does anyone know why? I did not have this problem with earlier mysql installations and do not have it on other machines. 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
