Error in query

[amir]

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]

have you tried registering the session to a variable beforehand?

[MattyUK]

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