0

I am using codeigniter with datatables , and when i put any Arabic letter on search input box i have Error message " Illegal mix of collations for operation 'like'" How to fix that Thanks

lala
  • 11
  • 1
  • make sure the input you are matching with the database must be `utf8_general_ci` or use `COLLATE` in your where clause – Nishant Nair Mar 09 '17 at 04:28
  • I am using utf8_general_ci in database , what the right way to use COLLATE in where clause $this->db->select('*'); $this->db->from('training'); $this->db->join('unversity', 'unversity.UnVerId = training.university'); $this->db->join('major', 'major.DeptID = training.major'); $this->db->join('cualification', 'cualification.CerID = training.cualification'); – lala Mar 09 '17 at 09:02
  • and works fine in localhost – lala Mar 10 '17 at 07:46
  • Possible duplicate of [Illegal mix of collations for operation 'like' while searching with Ignited-Datatables](https://stackoverflow.com/questions/18629094/illegal-mix-of-collations-for-operation-like-while-searching-with-ignited-data) – Hafez Divandari Nov 18 '17 at 18:37

0 Answers0