Filters input ignore Upper case / Lower case
Filters input ignore Upper case / Lower case
johngtrs
Posts: 33Questions: 2Answers: 0
Hi,
I have a problem with my filter input. How can I do to make a search ignoring upper case and lower case ?
This discussion has been closed.
Replies
https://datatables.net/reference/option/search.caseInsensitive
Yes I ever seen that but it doesn't work with my code.
You can see my code in my previous discussion : https://www.datatables.net/forums/discussion/29454/filter-and-sort-on-multi-data#latest
Filtering is being done at the server-side. Therefore this is an issue with the server-side script.
Likely you are using MySQL which does case insensitive filtering by default.
See MySQL manual and StackOverflow discussion.
Allan
Ok Allan thanks a lot i'll see that.
Edit : The problem is than i'm using this library https://github.com/m1ome/phalcon-datatables and i don't know how i can change the value of case insensitive server side.