How to create a Postgresql database with UTF-8 encoding in Ubuntu?

Question

PostgreSQL

How to create a Postgresql database with UTF-8 encoding in Ubuntu?

Answer 1

CREATE DATABASE "test"
  WITH OWNER "user"
  ENCODING 'UTF8'
  LC_COLLATE = 'ru_RU.UTF-8'
  LC_CTYPE = 'ru_RU.UTF-8';

Answer 2

createdb -E UNICODE %basename%