Thank you. On Wed, May 10, 2017 at 12:54 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote: > 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.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
