Hello Umit.

I tested both links:

https://dragoman.ist/glossary/military-test-2/

https://dragoman.ist/glossary/white-goods/

And search works on both of them.

I thought the first link was causing problems? If not, please tell me how that other table was created, and if you used some custom Query to create a table, possibly with JOINs?

If your MySQL-query based wpDataTable doesn’t work correctly with server-side processing, probably this is happening because wpDataTables server has problems with parsing of the query and building new queries dynamically (rarely happens, but does sometimes). To avoid this please prepare a MySQL view (a stored query), which will return the data that you need, call it e.g. “view1” and then build a wpDataTables based on a simple query like “SELECT * FROM view1″.

Please note some this when working with the server-side processing feature:

• Please do not use “LIMIT” in the SELECT statement. wpDataTables adds it automatically and it will be overridden.
• Please do not use “ORDER BY” in the SELECT statement. wpDataTables has its own sorting engine so it makes no sense to use MySQL’s sorting, since it will be overridden. Also, server-side processing feature adds this part of statement automatically when users trigger the sorting on the front-end, and having it in initial statement may cause the table to crash.

Best regards.

Alright, Umit

So that's one thing we can cross out on the list.

Can you, please, send me the CSV file in question, so I can test it in my local environment?

Just make sure you enable the Private reply slider, so it is visible only to us.

Best regards.

Hi again Umit.

I'm sorry but I cannot log in with those credentials:

It says the password is wrong.

Can you please check and let me know?

Best regards.

Hi again Umit

There's definitely something wrong with the format in the file. I see from its name that it's exported from Table Press, so I guess that is doing something with the characters.

Please take a look at the attached video. It looks like when I'm deleting characters, and get to language specific characters, I need to hit BACKSPACE twice for the letter to be deleted, because when I get to "ü" for example, I hit BACKSPACE once, and it turns to a simple "u". So, when I delete that letter and type in the actual "ü", save the file and use it to update the table on your website, the word appears again.

When I open the source file in a simple text editor, I see a difference in the look of the letters. Here's how some of them look when I open the file:

But, when I delete these and type them manually, they look like this:

See how the space between the two dots above the letters get smaller? Same goes for all other special characters. Can you export that Table Press table into Excel, or export without any formatting applied?

Best regards.