使用 Ignited-Datatables 进行搜索时，“like"操作的排序规则的非法混合
我已经成功地实现了 Ignited-Datatables.但是，在输入非拉丁"字符(如İ,ş,ğ,..")时使用数据库进行搜索时
I have successfully implemented Ignited-Datatables. However, while searching with database when typing "non-latin" characters like "İ,ş,ğ,.."
POST http://vproject.dev/module/user/ign_listing 500(内部服务器错误)
详情如下:
Illegal mix of collations for operation 'like' while searching
... (u.id_user LIKE '%Ä°%' OR u.first_name LIKE '%Ä°%' OR u.last_name LIKE '%Ä°%' OR ue.email LIKE '%Ä°%' OR u.last_login LIKE '%Ä°%' ) ...
%Ä°% 部分根据您输入的非拉丁字符而变化.
%Ä°% part changes according to the non-latin character you typed.
有解决这个问题的想法吗?
Any idea for solving this?
推荐答案
我找到了问题所在.似乎是 DATETIME 字段导致了问题.
I figured out the problem. It seems it is DATETIME fields that causes the problem.
.. ue.last_login '%ayşenur%'
为操作'like'操作的排序规则的非法混合给出错误.当我删除 LIKE 部分 DATETIME 字段时，不再有错误.我希望这会有所帮助.
gives error for Illegal mix of collations for operation 'like'. When I remove LIKE partials DATETIME fields, there are no error any more. I hope this helps.
相关文章