Postgresql: Searching a string with similar characters

Question

I have a POSTGRESQL Database with names like:

ʿImād ad-Daula Abu ᾽l-Ḥasan

The user may select this value by typing into a text field. But I would like the user to use similar characters. So, that he can type: "imad" or "hasan". And still get the same result.

It seems a kinda basic problem to me, but I have not found a solution so far.

I tried it with:

SELECT * FROM person WHERE name ILIKE '%hasan%' ORDER BY name ASC

But it doesn't work for these characters. I would be really greatful for suggestions.

Thanks

S-Man · Accepted Answer · 2021-03-03 12:24:36Z

1

You can install the extension unaccent:

CREATE EXTENSION unaccent;

And then you are able to do:

SELECT * FROM person WHERE unaccent(name) ILIKE '%hasan%' ORDER BY name ASC

answered Mar 3, 2021 at 12:24

S-Man

24k9 gold badges51 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sever van Snugg Over a year ago

Thanks, on a first glance, that works great! :)

Collectives™ on Stack Overflow

Postgresql: Searching a string with similar characters

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related