0

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?

Improve this question
3
  • Upgrade to a recent version and use case and accent insensitive ICU collations, which you can define yourself. If you cannot upgrade, and you cannot install an extension, you have to accept that you are too limited to get what you want. Commented Nov 21, 2021 at 2:34
  • @LaurenzAlbe I guess you mean PostgreSQL 12? Commented Nov 21, 2021 at 2:41
  • 2
    Technically yes, but at this point it would be silly to upgrade to anything less than v13, and I would recommend v14. Commented Nov 21, 2021 at 2:43
Load 7 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.