Postgres Pro
Downloads
Home   >   mailing lists

Client encoding not the same as the db encoding - Mailing list pgsql-general

From Clodoaldo Neto
Subject Client encoding not the same as the db encoding
Date
Msg-id CA+Z73LG5uU=skTJGCA31D01XZSzpn1nzPkP=4wTVk5TOO2eG6A@mail.gmail.com
Whole thread Raw
Responses Re: Client encoding not the same as the db encoding  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Tree view
In 9.1.3 the client encoding is not defaulting to the db encoding:

postgresql.conf:

#client_encoding = sql_ascii

=> show server_encoding;
 server_encoding
-----------------
 SQL_ASCII

=> show client_encoding;
 client_encoding
-----------------
 UTF8

In 9.0 the client encoding defaults to the db encoding:

postgresql.conf:

#client_encoding = sql_ascii

=> show client_encoding;
 client_encoding
-----------------
 SQL_ASCII

=> show server_encoding;
 server_encoding
-----------------
 SQL_ASCII

What am i missing? Regards, Clodoaldo

pgsql-general by date:

Previous
From: chinnaobi
Date:
Subject: Re: archive_cleanup_command recovery.conf Standby server error
Next
From: Adam Bruss
Date:
Subject: Re: accumulating handles problem on machine running postgresql