Customers Search & PostgreSQL ILIKE

[saschapapini]

Hi all, I have one problem with my PostgreSQL Database and OTRS. I have Customer's table in external database. I have link OTRS with my db and I map all. All works fine.
When I try to search a customers in my admin area I don't find any customers ... for example. If I search a customer with surname "Poggesi", the query is (i make a debug with my postgreSQL and OTRS):
SELECT usr , nome, cognome, email FROM clienti WHERE ((nome LIKE '%poggesi%' OR cognome LIKE '%poggesi%' OR email LIKE '%poggesi%') ) LIMIT 20
The problem is LIKE ... in PostgreSQL LIKE is casesensitive... the command to bypass casesensitive is ILIKE

It's possibile to change LIKE with ILIKE in configuration ??? Or if is not possibile, where is the file to modify in /opt/otrs/Kernel/System/?

Thanks
Sascha