character encoding

[Doug Kunzman]

I'm trying to support an automatic character encoding to UNICODE so Java
strings with none ASCII character can be stored in a table.

I've edited my postgressql.conf with the following command,
PGCLIENTENCODING=UNICODE

And I'm getting this error message,

FATAL: unrecognized configuration parameter "PGCLIENTENCODING"

Any ideas? your help would be appreciated.

Thanks, doug

[Adrian Klaver]

Post by Doug Kunzman
I'm trying to support an automatic character encoding to UNICODE so Java
strings with none ASCII character can be stored in a table.
I've edited my postgressql.conf with the following command,
PGCLIENTENCODING=UNICODE
And I'm getting this error message,
FATAL: unrecognized configuration parameter "PGCLIENTENCODING"
Any ideas? your help would be appreciated.

http://www.postgresql.org/docs/9.2/interactive/runtime-config-client.html#RUNTIME-CONFIG-CLIENT-FORMAT

client_encoding (string)
Sets the client-side encoding (character set). The default is to
use the database encoding. The character sets supported by
the PostgreSQL server are described in Section 22.3.1.

I believe PGCLIENTENCODING is the env setting.

Post by Doug Kunzman
Thanks, doug

[Condor]

Post by Adrian Klaver

Post by Doug Kunzman
I'm trying to support an automatic character encoding to UNICODE so Java
strings with none ASCII character can be stored in a table.
I've edited my postgressql.conf with the following command,
PGCLIENTENCODING=UNICODE
And I'm getting this error message,
FATAL: unrecognized configuration parameter "PGCLIENTENCODING"
Any ideas? your help would be appreciated.

http://www.postgresql.org/docs/9.2/interactive/runtime-config-client.html#RUNTIME-CONFIG-CLIENT-FORMAT
client_encoding (string)
Sets the client-side encoding (character set). The default is to
use the database encoding. The character sets supported by
the PostgreSQL server are described in Section 22.3.1.
I believe PGCLIENTENCODING is the env setting.

Post by Doug Kunzman
Thanks, doug

--
Adrian Klaver

PGCLIENTENCODING is env setting. You can set it before logging in to
database like:

PGCLIENTENCODING=win1251
export PGCLIENTENCODING

and then: psql -U x database


Regards,
Hristo Simeonov