Handle special chars

[robsontenorio]

Is there any alternative through configuration to ignore special chars like:

á -> a
õ -> o
ç -> c
...

By default Caché does not ignore when making a simple "where" with sql. Otherwise i must implement a translator helper at app level.

[jeandormehl]

Will have a look into this.

[robsontenorio]

Current workaround:

$name = Str::ascii($name);
 
where('name', $name);

Just wondering if there is a default config for this issue.

[jeandormehl]

I will add a configuration option for this and sanitize parameters passed before the queries run.

Will let you know when I get some time to actually do it.

[robsontenorio]

Please, dont. It is just workaround, i don't know if there is a best "native way" through drivers/PDO/ODBC config to do it.

[jeandormehl]

Hi, thanks for the pull requests.

I'm swamped at work but I will get to this probably this weekend.

[jeandormehl]

Hi Robson

Completely forgot about this, will revisit as soon as I'm back home later next week.

[robsontenorio]

The main problem here is at database level (Caché DB).

How do you currently manage a "like"? Considering the target fields has special chars/accents.

[jeandormehl]

I am extending from use Illuminate\Database\Query\Grammars\SqlServerGrammar;

I do not actually test the "like" part of queries and dont modify the values in this regard.

My best guess is that we would need to override a function, either where the variables are added to the sql or where the like statement is created.

I will investigate.

There could also possibly be an ODBC or PDO ATTR setting that could handle this for us. Will check Cache and PHP sites.

[robsontenorio]

On Caché legacy DB my company has created an internal custom function "removeAccents()"

So.. if name is joão i do place joao on like statement, and removeAccents() will turn it on joao. So it will work as expected.

where removeAccents(name) like "%joao%" `  

But I am really looking for a more native solution. No lucky.

[jeandormehl]

Hi

Yes, this can be easily fixed in one of the grammars.
I have a massive deadline for the 24th but this should be very simple to implement.

I will have a look as soon as I can.