Search error
Posted: Wed Jan 11, 2012 10:31 pm
I submit russian letters into search form at knowledge pages and get error:
SELECT id,parent FROM module_knowledge WHERE ((subject LIKE '%ывыв%' OR short_desc LIKE '%ывыв%' OR message_search LIKE '%ывыв%')) AND status=1 ORDER BY parent ASC
1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' (module_knowledge.php #120)
Backtrace:
index.php #118 -> module_knowledge.php #120
p.s: I don't try search something in russian here, just was wrong keyboard language.
SELECT id,parent FROM module_knowledge WHERE ((subject LIKE '%ывыв%' OR short_desc LIKE '%ывыв%' OR message_search LIKE '%ывыв%')) AND status=1 ORDER BY parent ASC
1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' (module_knowledge.php #120)
Backtrace:
index.php #118 -> module_knowledge.php #120
p.s: I don't try search something in russian here, just was wrong keyboard language.