encoding problems postgresql

Viewed 75

I am trying to do a search for Cyrillic names(rus name), but the function returns an empty list.

doctrine config


    'doctrine' => [
        'connection' => [
            'dbname' => 'app',
            'user' => 'app',
            'password' => 'secret',
            'host' => 'db',
            'driver' => 'pdo_pgsql',
        ]
    ]

Search function:

    $qb->andWhere('LOWER(user.name) LIKE :searchTerm')
                ->setParameter('searchTerm', strtolower('%' . $query['name'] . '%'));

What i tried:


    'charset' => 'SQL_ASCII' and 'charset' => 'utf8'

0 Answers
Related