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;
HI @Padmasree P
Use the below command..
CREATE DATABASE confluencedb WITH OWNER = CONFLUENCE_DB ENCODING 'UNICODE' LC_COLLATE 'C' LC_CTYPE 'C' TEMPLATE template0;
Hi Yohesh,
I need the db to have encoding and collation set to utf8 . not c collation. please help with utf8 command
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Are you using Windows/Linux?
Please have a look at the below answer.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Yogesh Mude - this link just saved me a LOT of time. I wish this was part of the official documentation. You have my deepest thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.