Accented characters in list filter

[karinep]

Hi everyone,

I have a list with some records and I have a record with a accented word, when I search for this record in list without the accent no records are founded and I would like this record returned too. Someone know in which file I have to change de SQL clause to do something with 'LIKE' not with '='? until now the only thing that I know is the file list.js in /media/com_fabrik/js/dist has a doFilter function which is called when the element lose the focus and somehow do the filtering, but I don't know which php file gets this field value and do the sql query.

Best regards,
Karine

 

[cheesegrits]

What collation are your tables set to?

-- hugh

 

[troester]

It's replicatable, but only in search all.

Search all is doing ... LOWER(column) regexp LOWER('searchstring') which needs exactly the accented character for matching.

Standard field search (...column LIKE '%searchstring%' ... resp. ...column = 'searchstring') is "accent insensitive" (so a finds also à and vice versa)