Re: character encoding of the postgres database

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(dot)klaver(at)aklaver(dot)com