| Micah Stevens 2005-10-21, 6:56 pm |
|
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]
|