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]
