How to Create a UTF8 database in PostgreSQL

Get the psql program to run the following command.

sudo -i -u postgres
psql

Then this will create a UTF8 database in PostgreSQL.

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

Postgresql is a solid database. Creating UTF8 databases for projects ensures that English and international characters are supported and ready for production.

Happy Coding!