How to create COLLATION for Brazilian Portuguese

Asked

Viewed 1,115 times

2

In the documentation says to create the collation thus:

CREATE COLLATION french (LOCALE = 'fr_FR.utf8');

This example is for France. How it would be for Brazilian Portuguese?

postgresql character-encoding locale

1 answer

3

pt_BR.utf8

To check which locales are available use:

SELECT * FROM pg_collation;
  • 1

    And when you do not have pt_BR.utf8 available?

  • 1

    In this case you have to search how to install on your operating system.

Browser other questions tagged postgresql character-encoding locale

You are not signed in. Login or sign up in order to post.