On Mon, Dec 21, 2009 at 10:26:51AM +0100, Durumdara wrote: > So if I have Python and pygresql, can I set this value in Python? > The main problem that I don't want to set this value globally - possible > another applications want to use another encoding...
Each connection can set the encoding to whatever they like. Something I find useful is to setup the DB as UTF-8 but then do: ALTER DATABASE foo SET client_encoding = latin9; which sets the default for the DB, or ALTER USER bar SET client_encoding = latin9; Which lets you set the defauts for each user. This means that old scripts can work unchanged but newer scripts can choose UTF-8 if they want it. Have a nice day, -- Martijn van Oosterhout <klep...@svana.org> http://svana.org/kleptog/ > Please line up in a tree and maintain the heap invariant while > boarding. Thank you for flying nlogn airlines.
signature.asc
Description: Digital signature
