Doctrine2 accents-insensitive search in DQL

Question

I didn't find anything good on that topic. Im currently implementing simple search function with will use LIKE to find requested records. But I wan't to make "accents-free" search.

For example: object name is: "Gdańsk", it should be found by string "Gdansk" and "Gdańsk".

If it was the other way around, it would be as simple as transforming search string, but since we have to transform the original value before comparision then it's little more diffcult.

Any help would be welcome.

Im using MySQL 5.5.

I had hope that it will not come to that and Doctrine has some nice solution. — Bartosz Rychlicki, Sep 14 '12 at 07:37
I don't have any solution purely with Doctrine, but with MySQL you can have a look to collations. — haltabush, Sep 14 '12 at 10:42

score 1 · Answer 1 · edited May 23 '17 at 12:21

1

This is related to MySQL only. See:

How to conduct an Accent Sensitive search in MySql

If you want an accent insensitive search, then use utf8_general_ci as your database collation.

edited May 23 '17 at 12:21

Community

1
1

answered Sep 14 '12 at 18:50

Keyne Viana

6,194
2
24
55

Doctrine2 accents-insensitive search in DQL

1 Answers1