collation problem in mysql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux