Hello.
I'm not sure about German version of Windows, but from using a Russian localization I've found that Windows console usually isn't as good as GUIs. However, if all German characters are correct if you're just typing them, then mysql command line client should be able to show the correct data. Start from reading: http://dev.mysql.com/doc/refman/5.0/en/charset.html http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html Götz M. Ritter wrote: > Hello there, > I'm new to MySQL and have just installed the 5.0 on a WinXP-Workstation. > > I have a question concerning the use of the shell-interface of my > mysql-Installation. > > To load data in a table > I used WinXP-Notepad to create tab-separated records (they contain > special german chars ("Umlaute") > I used the LOAD DATA LOCAL INFILE-Statement to import the data. > > Everything seems to be OK, but when I make a SELECT in the shell, the > special characters are shown scrambled. > Is that wright or did I make a mistake? > Thanks for answering, > sincerely, > Goetz (german name with "Umlaut", ;-) ) > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]