I just read the post 'MySQL 4.1 and Unicode produces crap' on Dec. 6 by Yves Goergen. I guess we are having the same issue.
I notice that 4.1.0 if I do "SHOW VARIABLES LIKE "char%"', there is only one setting, however, in 4.1.7 there are different characterset. I did tried to change all variables to use utf8, but the problem still exist. Is there anybody could help? Or did I asked the question in a wrong group? Thank you. Francis Mak -----Original Message----- From: Francis Mak [mailto:[EMAIL PROTECTED] Sent: Friday, December 03, 2004 7:42 PM To: [EMAIL PROTECTED] Subject: characterset problem 4.1.7 Dear all, I was using mysql 4.1.0, all table use utf8. I can use php to store and display utf8 character without any problem. Yesterday I upgraded 4.1.0 to 4.1.7. I use mysql-control-center and I can see the data in 4.1.7 are utf8 characters. However, when I use my php program to display it, all things become ??? I supspect it is due to the client connection? What config I need to do in order to make php display correctly? Please Please! Thank you very much. Francis Mak -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]