Log in

HCMC Journal

PostgreSQL 12 unicode handling

: Greg Newton
Minutes: 15

Doing a search that does not contain accented characters does not return results that do contain accented characters.

You can get part of the way there using PostgreSQL extensions though.

There’s an extension called ‘normalize’ that you can activate as long as you’re using v13 or newer - we’re on v12:(

There’s another extension called ‘unaccent’ that you can activate, and it works in v12, but getting it to work requires that you do the following:

  1. Create the extension
  2. You can only use it if you’re in the public schema, so we need to alter it using ‘SET SCHEMA’.