Hi
Someone can tell me How can i resolve this problem
"1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' SQL=SELECT COUNT(*) FROM jos_comprofiler_plug_profilebook WHERE postername = 'someone' AND posteremail = 'user@gmail.com' AND postertitle = '' AND postercomment = 'Δεν' AND posterid = 42 AND userid = 42"
trying to post in Greek language at the wall. I have install cb on xampp
sfitsoula wrote: Hi
Someone can tell me How can i resolve this problem
"1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' SQL=SELECT COUNT(*) FROM jos_comprofiler_plug_profilebook WHERE postername = 'someone' AND posteremail = 'user@gmail.com' AND postertitle = '' AND postercomment = 'Δεν' AND posterid = 42 AND userid = 42"
trying to post in Greek language at the wall. I have install cb on xampp
(Γεια σου!)
Your database collations are mixed - everything should be utf8_general_ci.
Check your database tables and also all your text columns and change where needed using phpmyadmin.