Can we set the locale (lc_collate, lc_ctype) of a database other than the default "C"?

Support
1

Like the SQL: CREATE DATABASE us_test_db LOCALE ‘en_US.utf8’;

4 Likes
2

Hi @uldin,

We have a plan to allow users to first do CREATE DATABASE ... on their own, then to allow specifying different locales. Yet, no ETA on this so far. My best guess that it’s likely to happen somewhere in the Q1 2023

3

Does anyone have any news about this?

1 Like
4

Hi! Any news about this?

5

Hi! We now allow CREATE DATABASE in SQL, but I don’t think that we have different locales yet

1 Like
6

Thanks, this worked for me!

CREATE DATABASE testdb
    WITH
    ENCODING = 'UTF8'
    LC_COLLATE = 'en_US.UTF8'
    LC_CTYPE = 'en_US.UTF8'
    TEMPLATE = template0
    ;