Arabic language search in codeigniter error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)
Check the connection for being character set utf8
Check the application for whether it is using UTF-8


Meanwhile, that looks like an awfully slow query -- lots of ORs and leading wildcard on LIKEs.