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
