confluence db in postgres

Padmasree P

how do we create confluence db with postgres character encoding and collation set to utf8

I'm following this document for setting up postgres db . 

https://confluence.atlassian.com/conf67/database-setup-for-postgresql-945103516.html

will this command work 

CREATE DATABASE "confluence_db"
WITH OWNER "postgres"
ENCODING 'UTF8'
LC_COLLATE = 'en_US.UTF-8'
LC_CTYPE = 'en_US.UTF-8'
TEMPLATE template0;

 

Yogesh Mude_u145qk

HI @Padmasree P

Use the below command..

CREATE DATABASE confluencedb WITH OWNER = CONFLUENCE_DB ENCODING 'UNICODE' LC_COLLATE 'C' LC_CTYPE 'C' TEMPLATE template0;