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