Setting environment variables for PostgreSQL
Andreas Tille
tillea at rki.de
Mon Feb 19 14:58:20 CET 2007
Hi,
when facing a font encoding problem during a migration from
PostgreSQL 7.4 to 8.1 I found out that setting the client
encoding explicitely via
SET CLIENT_ENCODING='iso-8859-1';
solves this. This can be enforced using an environment
variable
export PGCLIENTENCODING=LATIN1
which works perfectly if I use psql as client. So I tried
both
1. Adding
export PGCLIENTENCODING=LATIN1
on top of /etc/init.d/zope2.9 and
2. adding
PGCLIENTENCODING=LATIN1
to /etc/default/zope2.9
on a quite recent testing machine. Unfortunately I can not
see any result and wonder, whether the environment variable
setting is destroyed anywhere in the startup proces or whether
there might be another reason for this problem.
BTW, I tried to set the encoding directly in the
Z Psycopg Database Connection
object, as 'LATIN1' without any success as well
Kind regards
Andreas.
--
http://fam-tille.de
More information about the pkg-zope-developers
mailing list