Re: [Gnumed-devel] locale/config ?

[Karsten Hilbert]

On Fri, Sep 01, 2006 at 01:01:39AM -0400, Linux Surd wrote:

> I recently installed from CVS and the backend on FC5. I wanted to see if I
> can connect to the public database first... but ran out of luck. I get the
> following message:
> [ERROR] (/home/gmadm/gnumed/gnumed/Gnumed/pycommon/gmPG.py:address@hidden):
> query [set client_encoding to 'utf']
> [PANIC] (/home/gmadm/gnumed/gnumed/Gnumed/pycommon/gmPG.py:address@hidden):
> cannot set string-on-the-wire client_encoding on connection to [utf], this
> would likely lead to data corruption
Try setting

 wire encoding = 

in the .conf file to either of "utf", "utf8", "utf-8" or
"unicode". One should work. All of them work for me for some
reason.

The wire encoding needs to be the same as the "string
encoding" which you should set there, too, and has to be a
label that PostgreSQL recognizes. This seems to differ
between versions of PG and libpq. Hence the setting.

Future versions will use psycopg which alleviates some of
the pains of this whole issue.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346