Bug when filtering words with accents

[pabloroxo]

Hi, Arjay!

I'm facing a bug when fitering by term.

For example: I list users and there is a user called "Tatiane Simões". Note the "õ". If I search for "simões", it will show in the list. But sometimes we don't type the accents. We just put "simoes" in the field and expect that "Tatiane Simões" will be listed. But it's not.

Is there any way we could ignore these accents when filtering? Maybe adding some boolean option, like in other options in "/vendor/yajra/laravel-datatables-oracle/src/config/datatables.php". If yes, here's a list of letters with accents in portuguese brazilian which we'd love to be replaced:

Ã/ã/Á/á/À/à/Â/â = a
É/é/Ê/ê = e
Í/í = i
Ó/ó/Ô/ô/Õ/õ = o
Ú/ú = u
Ç/ç = c

We don't use other combinations of letter and accents.

Thank you!

[pabloroxo]

Just adding some more information: when Eloquent performs the query like select * from users where name like '%simoes%';, "Tatiane Simões" is retrieved, but it is removed when we use your DataTables::of($results)->....

[yajra]

Not sure, but I think this should be on the database level character set / collation settings?

[pabloroxo]

Let me show an example:

This is the list using DataTables with server-side processing and your lib in laravel backend.

If I search for "simões", then the list is loaded correctly, with "Tatiane de Jesus Simões":

But if I type "simoes", it will show nothing:

If I put a dd() to debug the query done by eloquent, we notice that we bring all 647 records:

Leaving us with the only reason to be filtering and excluding in your method that builds the result that returns the data to be fetched:

[pabloroxo]

So, my suggestion is that you implement replacing characters, for example from "õ" to "o" and "Õ" to "o" (considering everything is transformed to lowercase) BEFORE searching for the substring in "search[value]", passed through the request:

Accents are used in many many languages, even in english, with some words like "fiancé", "resumé" and "façade".

Or if you don't consider it a feature to be developed, maybe give me instructions for where I can implement it.

Thank you!

[pabloroxo]

Well, I solved this by editing your code (/vendor/yajra/laravel-datatables-oracle/src/CollectionDataTable.php):

I know it's an HORRIBLE solution, plus using a deprecated function in PHP 8.2 (although I'm using PHP 8.0), but... it works!

I'll leave this as suggestion for a next release!

Thanks!