How to set utf8 locale for postgresql?

Question

PostgreSQL

When init, the database gives the application an error: UnicodeEncodeError
: 'latin-1' codec can't encode characters in position 0-6: ordinal not in range(256 ) 'UTF8'; ERROR: encoding UTF8 does not match locale en_US DETAIL: The chosen LC_CTYPE setting requires encoding LATIN1. I set the ru_RU locale to the originally English ubuntu, but all attempts to reassign the locale for postgres were unsuccessful.

Answer 1

I struggled with this myself for a long time.
Turn on the console
Delete the old database cluster
pg_dropcluster --stop 9.1(cluster version) main(cluster name, you can get pg_lsclusters)
Create a new cluster
pg_createcluster --locale de_DE.UTF-8 --start 9.3 main
In this case, the locale must be set
dpkg- reconfigure locales

Answer 2

to this we also need to add TEMPLATE = template0.
those. succeed

CREATE DATABASE "имя_базы"
  WITH OWNER "postgres"
  ENCODING 'UTF8'
  LC_COLLATE = 'ru_RU.UTF-8'
  LC_CTYPE = 'ru_RU.UTF-8'
  TEMPLATE = template0;

Answer 3

Try like this:

CREATE DATABASE "имя_базы"
  WITH OWNER "postgres"
  ENCODING 'UTF8'
  LC_COLLATE = 'ru_RU.UTF-8'
  LC_CTYPE = 'ru_RU.UTF-8';