Re: [GENERAL] 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.klaver@aklaver.com