I discovered that text filtering sometimes takes into account capitalization and sometimes it doesn't. For example, one of my tables displays simple records straight from the database and the search (both for columns and global) takes capitalization in account (not ideal), while another table that contains foreign key relations for multiple columns does not and works great.
My question is whether there is an option to solve this so that records filter regardless of whether the entered string is capitalized or not.
This is not related to our Plugin directly, but rather it depends on which Database collation is set on the source DB table from where the data is being pulled.
Please check on your Database Management Tool, such as PHPMyAdmin or any other - find this source DB table and check if you got a 'case sensitive' collation set on it, that would explain the issue.
You then need to change it to any 'case insensitive' DB collation for that table ( and any other that has the same issue), after that any search or filtering should work as 'case insensitive'.
You can check the collation for each table and column - basically, any collation that has 'ci' at the end will work.
Compared to any ending with 'cs', which is 'case sensitive'. Let us know if you require any further assistance on this matter. Thank you.
I am delighted to hear that this has been resolved. Thank you for letting us know. Anything else that we could assist with, please don't hesitate to create new tickets.
We will respond to the remaining open ticket as soon as possible, too, of course.
Hi there,
I discovered that text filtering sometimes takes into account capitalization and sometimes it doesn't. For example, one of my tables displays simple records straight from the database and the search (both for columns and global) takes capitalization in account (not ideal), while another table that contains foreign key relations for multiple columns does not and works great.
My question is whether there is an option to solve this so that records filter regardless of whether the entered string is capitalized or not.
Thanks in advance,
Rok
Hi Rok,
This is not related to our Plugin directly, but rather it depends on which Database collation is set on the source DB table from where the data is being pulled.
Please check on your Database Management Tool, such as PHPMyAdmin or any other - find this source DB table and check if you got a 'case sensitive' collation set on it, that would explain the issue.
You then need to change it to any 'case insensitive' DB collation for that table ( and any other that has the same issue), after that any search or filtering should work as 'case insensitive'.
You can check the collation for each table and column - basically, any collation that has 'ci' at the end will work.
Compared to any ending with 'cs', which is 'case sensitive'.
Let us know if you require any further assistance on this matter.
Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Miloš,
Thanks for your speedy reply, that's exactly what it was!
Best,
Rok
Hi Rok,
I am delighted to hear that this has been resolved. Thank you for letting us know.
Anything else that we could assist with, please don't hesitate to create new tickets.
We will respond to the remaining open ticket as soon as possible, too, of course.
Thanks again.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables