You're sending the query in a different encoding than the server is expecting it looks like, or perhaps somehow mixing encodings somehow? Although that doesn't make sense. I'd check the default PHP encoding versus what mysql is set up for. -Micah On Friday 21 October 2005 1:07 am, Anom wrote: > hi all, > > i have a problem using mysql, when i execute this sql : > > SELECT phplib_id FROM subscriber WHERE user_id = 'admin' AND password = > 'hello' > > i got the following error message : > Illegal mix of collation (latin1_swedish_ci, IMPLICIT) and > (utf_general_ci, COERCIBLE) for operation '=' > > i have read through the mysql doc but still i had a confusion on how > to solve the problem. Is there any suggestion from any of you on how > to solve this problem??? > > -- > Ade Anom A > [http://www.a3rex.info] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
