Not case-sensitive search for postgresql in symfony 5.2

[AntonA46]

Hello! Table searches are performed using the "LIKE" operator, which is case sensitive in postgresql. In MYSQL There is no such problem. How fix this problem ?

[AntonA46]

Decision: Need to use SearchCriteriaProvider in ORMAdapter. In my case:

'criteria' => [
function (QueryBuilder $ queryBuilder, DataTableState $ state) {
$ state-> setGlobalSearch (mb_strtoupper ($ state-> getGlobalSearch ()));
},
new SearchCriteriaProvider (),].

In the dataTable constructor, in the added columns, add

'field' => 'upper (u.name)',
'searchable' => true,