I started to build a new web page and I need and want to buy a plugin like wpdatatable. I added it a "test" wordpress installation but I have a problem.
I 've got an uppercase-lowercase problem. I am using "wpdatatabe with excel file" . It works great and I can see the records on my page. There is a record like "ÇELİK" , but when I search the word "çelik" in lowercase, it can't find the record. Only uppercase works. I think this is about Turkish characters because, there is a lower "i" character and upper "İ" caharacter in Turkish. And also there is lower "ı" and upper "I" caharacter.
Sorry for the delay in our responses, has been national holidays in our country for the last two days.
Aleksandar is on vacation and I will help you out.
When you create table with option "Create table from existing data source" like in your case, for table functionality like searching, sorting is responsible Datatables engine(jQuery plugin) on which is based our plugin. They support searching for a different characters(lowercase or uppercase) but from some reason Turkish letter "İ" can not be found if you are using it as lowercase.
My suggestion is to use third option in table wizard "Create tables by importing data from data source" and to import your file. Like this it will be created manual table in database with your data and searching in this cases is based on wpDataTables logic for server-side tables like this one and search will work like you need.
Hi
Can I remove table tools such as “Copy”, “Print”, “Excel”, etc.?
Edit : Sory, I found it in the menu. Thank you.
Hello Veyis
Thank you for letting us know the issue has been resolved.
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
Kind Regards,
Aleksandar Vuković
[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 Aleksandar.
I started to build a new web page and I need and want to buy a plugin like wpdatatable. I added it a "test" wordpress installation but I have a problem.
I 've got an uppercase-lowercase problem. I am using "wpdatatabe with excel file" . It works great and I can see the records on my page. There is a record like "ÇELİK" , but when I search the word "çelik" in lowercase, it can't find the record. Only uppercase works. I think this is about Turkish characters because, there is a lower "i" character and upper "İ" caharacter in Turkish. And also there is lower "ı" and upper "I" caharacter.
What should I do to solve problem?
the URL of test page is : https://veyissen.com.tr/1304-2/
Hello again Veyis
This can probably be fixed with changing the collation of the database. Try changing the collation of the column to utf8_turkish_ci in the database:
Can you send me the source table, so I can test it locally? If the file contains personal data, make sure to enable PRIVATE response.
Kind Regards,
Aleksandar Vuković
[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
Hello again Veyis,
Sorry for the delay in our responses, has been national holidays in our country for the last two days.
Aleksandar is on vacation and I will help you out.
When you create table with option "Create table from existing data source" like in your case, for table functionality like searching, sorting is responsible Datatables engine(jQuery plugin) on which is based our plugin. They support searching for a different characters(lowercase or uppercase) but from some reason Turkish letter "İ" can not be found if you are using it as lowercase.
My suggestion is to use third option in table wizard "Create tables by importing data from data source" and to import your file. Like this it will be created manual table in database with your data and searching in this cases is based on wpDataTables logic for server-side tables like this one and search will work like you need.
Best regards
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables