How do I get the UTF8 collation on PostgreSQL running on WIndows

[Joe Olinger]

I am running Windows 10 PostgreSQL 9.6 and confluence 7.x.x.  How do I the collation to be en_US.UTF8?

[Stan Ry]

Hi Joe,

Try this:

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