Re: [SQLObject] setting db encoding with postgresql

2008-02-17 Thread Max Aginaga
Hi Oleg! Thank you for your reply, the trouble was with the machine's locale settings... All the best Max On Feb 15, 2008 12:35 AM, Oleg Broytmann <[EMAIL PROTECTED]> wrote: > On Fri, Feb 15, 2008 at 08:29:52AM +0300, Oleg Broytmann wrote: > >I use PostgreSQL, and all my databases are in U

Re: [SQLObject] setting db encoding with postgresql

2008-02-14 Thread Oleg Broytmann
On Fri, Feb 15, 2008 at 08:29:52AM +0300, Oleg Broytmann wrote: >I use PostgreSQL, and all my databases are in UTF-8, but I never was in > need to set client_encoding. I use UnicodeCol()umns with default UTF-8 > encoding, and they pass data to and fro Pg in utf-8, no problem so far. > Locale at

Re: [SQLObject] setting db encoding with postgresql

2008-02-14 Thread Oleg Broytmann
On Thu, Feb 14, 2008 at 06:32:06PM -0500, Max Aginaga wrote: > I am using SQLObject-0.10.0b2 on Postgresql 8.3. The database is using > UTF8 as its encoding. > > I am connecting to the db with the connectionURI > > "postgres://%s:[EMAIL PROTECTED]/%s"%(DB_USERNAME, DB_PASSWORD, DB_HOST, > DB_NAM

[SQLObject] setting db encoding with postgresql

2008-02-14 Thread Max Aginaga
Hello, I am using SQLObject-0.10.0b2 on Postgresql 8.3. The database is using UTF8 as its encoding. I am connecting to the db with the connectionURI "postgres://%s:[EMAIL PROTECTED]/%s"%(DB_USERNAME, DB_PASSWORD, DB_HOST, DB_NAME) The connection succeeds, but I cannot insert anything into the