nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Confluence on PostgreSQL, what collation is recommended?

VLADIMIR MURAVLEV

Article named "Database Setup for PostgreSQL" says that collation must be set no other than "UTF8".
Quote: "Collation must also be set to utf8. Other collations, such as "C", are known to cause issues with Confluence. "
This collation is possible to set up for PostgreSQL running on Linux, but this value is not supported on Windows.
Available values are: C, POSIX, English_United States.1252
Which one is recommended value for Confluence?

What is risk using one of these available values?

Accepted answers

Shannon S

Hi Vladimir,

According to Postgres:

UTF-8 encoding can be used with any locale.

In addition, I reviewed this blog post, Locale in Windows, and it appears that you should be able to use English_United States.1252.

I was also able to confirm this by reviewing some of our past support tickets, so please give that a try, and let me know if you have any trouble!

Regards,

Shannon

All comments

Shannon S

Hi Vladimir,

According to Postgres:

UTF-8 encoding can be used with any locale.

In addition, I reviewed this blog post, Locale in Windows, and it appears that you should be able to use English_United States.1252.

I was also able to confirm this by reviewing some of our past support tickets, so please give that a try, and let me know if you have any trouble!

Regards,

Shannon

VLADIMIR MURAVLEV

Thank you Shannon.

I configured database using Collation English_United States.1252 and restored backup (migrated from Oracle). No apparent problems so far.

Shannon S

Glad to hear, Vladimir! If you run into anything do let us know.

Shannon

Deswik IT

Can this doco be updated to reflect the above advise please https://confluence.atlassian.com/doc/database-setup-for-postgresql-173244522.html