Re: Character Encoding Question

On 28/03/13 22:07, Don Parris wrote:
> From the postgresql.conf file:
> #client_encoding = sql_ascii        # actually, defaults to database
> encoding
>
> The way I understand it, the client should default to whatever encoding
> the DB uses.  Sounds like they tried to make it difficult to do what I
> apparently did.

Yes, you're right.  However, when you do the cluster initdb, the
template0 database gets created with whatever encoding is specified to
initdb (IIRC nowadays the default is UTF-8, but in some previous version
the default used to be SQL_ASCII).  After that, any createdb that
doesn't specify an encoding defaults to the template0 encoding.  So if
your template0 has SQL_ASCII encoding, it's very easy to create a
database with that encoding.

Joe