I am running Windows 10 PostgreSQL 9.6 and confluence 7.x.x. How do I the collation to be en_US.UTF8?
Hi Joe,
Try this:
<span>CREATE</span> <span>DATABASE</span> <span>"example_db"</span> <span>WITH</span><span> OWNER </span><span>"postgres"</span><span>ENCODING </span><span>'UTF8'</span><span>LC_COLLATE </span><span>=</span> <span>'en_US.UTF-8'</span><span>LC_CTYPE </span><span>=</span> <span>'en_US.UTF-8'</span><span>TEMPLATE template0</span><span>;</span>
It looks like you're new here. Sign in or register to get started.