Encoding Index Page 1

How to change postgresql database encoding to UTF8 from SQL_ASCII

In this tutorial, we explain how to change the encoding of a database in PostgreSQL. Use sudo -u postgres psql -C “SHOW SERVER_ENCODING” your_database to display the database encoding. You can create a new database with utf8 using the command: sudo -u postgres createdb -E utf8 your_database. If you already have a database with SQL_ASCII and you want to convert it to utf8 you will need to regenerate it, check here for the full guide.