collation/character set must be setup to utf-8 due to https://jira.atlassian.com/browse/CONFSERVER-54305

[gkowalc]

For JIRA postgres database collation/character set "C" is OK. However Confluence requires utf-8 otherwise you will experience problems with saving/opening attachment with upper-case special character in attachment filename (see https://jira.atlassian.com/browse/CONFSERVER-54305 for more details)

[blacklabelops]

That's very confusing. I find different solutions everywhere. "utf-8", "utf8", "UTF-8". It would be really nice if someone can contribute the correct create table statement for postgres.

[rwarren]

See this for more info (instructions how to convert):

https://confluence.atlassian.com/confkb/how-to-fix-the-collation-of-a-postgres-confluence-database-966676071.html

Also: Confluence now warns you at boot (in the web UI) if your database is using anything other than the "UTF-8" collation.

Note that it is not a create table thing, but a database level thing.

[rwarren]

Also note that setup instructions in the README.md need to change to stop saying POSTGRES_COLLATE=C and POSTGRES_COLLATE_TYPE=C

[jhult]

@rwarren, can you submit a pull request?

[gkowalc]

I have updated docs in pull request updated postgres readme docs #78 once PR is approved we can close this issue,