Re: character encoding of the postgres database

Thank you.

On Wed, May 10, 2017 at 12:54 PM, Adrian Klaver
<adrian(dot)klaver(at)aklaver(dot)com> 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(dot)klaver(at)aklaver(dot)com