How to make diacritics insensitive queries in PostgreSQL, without unaccent extension?

485 Views Asked by At

I need to do queries ignoring diacritics (and case) in PostgreSQL 9.3. Everything I've found about it (e.g. here, here and here) requires the installation of the unaccent extension. However, I cannot have it installed on my server.

Is there another way to do it?

0

There are 0 best solutions below