Hello.
Most probably you should set the correct character sets. Search on the list similar problems are often met there. See: http://dev.mysql.com/doc/mysql/en/charset-defaults.html What output does the following statement produce: show variables like '%char%'; Send the output of: show create table your_table; Carl Seghers <[EMAIL PROTECTED]> wrote: > Hi there, > > Question: I have a database with names that may contain accented > characters like $ or $. My charset & collation are the defaults latin1 > & latin1_swedish_ci. > > In my browser all characters come out all right (both in phpMyAdmin and > in my application), but when I open a command console (mysql.exe) all > characters look messed up. Manually typing accented characters works, > but they do not match the ones in the database. > > E.g. The name C$line is in the database, I see C$line in the browser, > but I see C8line in the console. Manually requesting the record of > C$line (select * from individuals where name='c$line') fails. The funny > thing is that the C8line record *is* found when I type the request > without accents (select * from individuals where name='celine')? > > Does anybody know how to make the console show and accept the accented > characters? > > Thanks > Carl > -- 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]
