Join Stack Overflow to learn, share knowledge, and build your career.
I have successfully implemented Ignited-Datatables. However, while searching with database when typing "non-latin" characters like "İ,ş,ğ,.."
Details are:
Any idea for solving this? |
|||||
|
I figured out the problem. It seems it is DATETIME fields that causes the problem.
gives error for |
|||||||||||||||||||||
|
Try the following:
Refer to MySQL Unicode Character Sets Also you can refer to MySQL _bin and binary Collations for more information on
|
|||||||||||||||||||||
|
i know that this is far too late, but, here my workaround.
datetime/date column gives error for Illegal mix of collations for operation 'like', therefore, by converting it, as another table entity, previous column type will be replace with varchar type. also, make sure to convert any column before convert it to temporary table, to make matching process more easier. |
|||||
|
Your Answer
By posting your answer, you agree to the privacy policy and terms of service.
Not the answer you're looking for? Browse other questions tagged mysql codeigniter activerecord datatable or ask your own question.
asked |
4 years, 3 months ago |
viewed |
7,928 times |
active |
- Software Quality Assurance EngineerPlatform.shNo office locationREMOTE
High response rate
-
Work remotely - from home or wherever you choose.
Linked
Related
STACK OVERFLOW
STACK OVERFLOW
BUSINESS
COMPANY
site design / logo © 2017 Stack Exchange Inc; user contributions licensed under cc by-sa 3.0 with attribution required.rev 2017.12.20.28229