Wallpapers Forums Login

Illegal Mix Of Collations (latin1_swedish_ci,implicit) And (utf8_general_ci,coercible) For Operation

Posted On Thu Dec 18, 2008 By hostman In MySQL Forums And Topics Discussions About Open Source Database Forums

im getting this error on a doulble query from mysql database:

IError

SQL-query: Documentation

SELECT w.wallpaper_id, w.wallpaper_url, c.wall_category_name
FROM wallpaper w, category c
WHERE w.status = 'L'
ORDER BY w.wallpaper_views DESC
LIMIT 0 , 12

MySQL said: Documentation
#1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

rene Sun Mar 20, 2011

Before you connect you may try: SET collation_connection = latin1_spanish_ci;
works for me.

Oscar Thu Aug 13, 2009

lo que pasa es que estÃ¡s comparando con cosas nulas o que preformateaste con encoding iso, te aconsejo que veas lo que estÃ¡s comparando.

arin Thu Jan 01, 2009

i used to see this error only when i did two quieries in one, but when i only query one table it did appear on my scrpt

mysql Thu Jan 01, 2009

what i did to fix this was i went to phpmyadmin and change the table to utf8_general_ci and after that i didnt get the error anymore

#1267 - illegal mix of collations (latin1_swedish_ci,implicit) and (utf8_general_ci,coercible) for operation =

check it out

Information

Forums »
MySQL Forums And Topics Discussions About Open Source Database »
Illegal Mix Of Collations (latin1_swedish_ci,implicit) And (utf8_general_ci,coercible) For Operation

Title: Illegal Mix Of Collations (latin1_swedish_ci,implicit) And (utf8_general_ci,coercible) For Operation

Description: Illegal Mix Of Collations (latin1_swedish_ci,implicit) And (utf8_general_ci,coercible) For Operation

Tags: illegal ,mix ,of ,collations ,latin1 ,swedish ,ci ,implicit ,and ,utf8 ,general ,ci ,coercible ,for ,operation

Info: This Post Has Been Viewed 0 Times Since
Date: Thu Dec 18, 2008
Author hostman Received 4 Replies #910

Mysqldump Only Certain Tables With Wild Card

Illegal Mix Of Collations (latin1_swedish_ci,implicit) And (utf8_general_ci,coercible) For Operation

Related Content

Information

Share