Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] character encoding of the postgres database - Mailing list pgsql-general

From Sandeep Gupta
Subject [GENERAL] character encoding of the postgres database
Date
Msg-id CAAywg7u-Pi3D1TUsSsyHEQcZ6bAT9KALxVKE5qECRQsnLy3X6A@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] character encoding of the postgres database  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Re: [GENERAL] character encoding of the postgres database  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view 
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.

Thanks
sandeep

pgsql-general by date:

Previous
From: Mathieu Fenniak
Date:
Subject: Re: [GENERAL] Logical decoding CPU-bound w/ large number of tables
Next
From: Brian Dunavant
Date:
Subject: Re: [GENERAL] Select from tableA - if not exists then tableB