On 05/10/2017 08:48 AM, Sandeep Gupta wrote:
Currently, the postgres database by has SQL_ASCII encoding.psql -p 5771 postgres -l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -----------+---------+-----------+---------+-------+--------------------- postgres | sandeep | SQL_ASCII | C | C | template0 | sandeep | SQL_ASCII | C | C | =c/sandeep + | | | | | sandeep=CTc/sandeep template1 | sandeep | SQL_ASCII | C | C | =c/sandeep + | | | | | sandeep=CTc/sandeep (3 rows) Is it possible to start the postgres database with UTF-8 encoding, instead of modifying it later.
See Peter's post, just remember that SQL_ASCII is essentially no encoding so be prepared for issues. I would test before doing this on live data.
Thanks sandeep
-- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
