Open gkowalc opened 6 years ago
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.
See this for more info (instructions how to convert):
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.
Also note that setup instructions in the README.md need to change to stop saying POSTGRES_COLLATE=C
and POSTGRES_COLLATE_TYPE=C
@rwarren, can you submit a pull request?
I have updated docs in pull request updated postgres readme docs #78 once PR is approved we can close this issue,
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)