PDA

View Full Version : Error in query


amir
04-29-2005, 03:58 PM
Query = "select * from tmp_images where session_id = '".$_SESSION['id']."'"


Error = #1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

Regards,
Aamir.

pdug175
04-29-2005, 06:46 PM
have you tried registering the session to a variable beforehand?

MattyUK
04-29-2005, 07:51 PM
My guess is the server is generating its characters in UTF and (it is this way on linux boxes often) and the database is set to latin and finding a conflict. Have you tried adjusting the field charset to utf8 or the database Collation generally?

MattyUK