Illegal Mix Of Collations (latin1_swedish_ci,implicit) And (utf8_general_ci,coercible) For Operation
- Forums
- MySQL
- Illegal Mix Of Collations (latin1_swedish_ci,implicit) And (utf8_general_ci,coercible) For Operation
This Page Contains information about Illegal Mix Of Collations (latin1_swedish_ci,implicit) And (utf8_general_ci,coercible) For Operation By wallpaperama in category MySQL with 4 Replies. [910], Last Updated: Sat May 18, 2024
wallpaperama
Thu Dec 18, 2008
4 Comments
3500 Visits
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 '='
works for me.
https://www.wallpaperama.com/forums/illegal-mix-of-collations-latin1-swedish-ci-implicit-and-utf8-general-ci-coercible-for-operation-t68.html