"Illegal mix of collations for operation 'like'" utf8 search error

Question

giorgiberia opened this issue 3 years ago · 3 comments

when I try to search something other than ASCII backend throws this error. i followed the docs described and every other aspect works very well

Answer 1 · 2021-08-18T16:53:34.000Z

I think this is not related to DRF-datatables but just your database table encoding.

Answer 2 · 2021-08-20T05:53:44.000Z

database table encoding is utf8-general-ci

Answer 3 · 2021-11-04T11:23:27.000Z

I'm pretty sure this is not related to DRF-datatables, since we use standard Django filtering.
Did you see this article https://tableplus.com/blog/2019/08/illegal-mix-of-collations-mysql.html ? It may solve your problem.