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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
