Thread: [SQLObject] setting db encoding with postgresql
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Max A. <max...@gm...> - 2008-02-14 23:32:09
|
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:%s@%s/%s"%(DB_USERNAME, DB_PASSWORD, DB_HOST, DB_NAME) The connection succeeds, but I cannot insert anything into the db: I get an exception which ends in ProgrammingError: invalid byte sequence for encoding "UTF8": 0xfe HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding". The trouble is that appending "?client_encoding=utf-8" to the connection URI generates the error DBConnection.__init__(self, **kw) TypeError: __init__() got an unexpected keyword argument 'client_encoding' I searched online and in the source code and could find references to other args ('dbEncoding' and 'encoding'), but those are not recognized by the DBConnection constructor, either. How can I set the encoding for use with a Postgresql db? Any help would be great since I am stuck. Thank you for any advice, Max |
From: Oleg B. <ph...@ph...> - 2008-02-15 05:29:55
|
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:%s@%s/%s"%(DB_USERNAME, DB_PASSWORD, DB_HOST, DB_NAME) > > The connection succeeds, but I cannot insert anything into the db: I > get an exception which ends in > > ProgrammingError: invalid byte sequence for encoding "UTF8": 0xfe > HINT: This error can also happen if the byte sequence does not match > the encoding expected by the server, which is controlled by > "client_encoding". > > The trouble is that appending "?client_encoding=utf-8" to the > connection URI generates the error This is only valid for MySQL backend. PostgreSQL backend in SQLObject doesn't know anything about encodings. 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 the client part is koi8-r or windows-1251. If UnicodeCol() don't help, it would be helpful to see a small test program that demonstrates the problem. Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: Oleg B. <ph...@ph...> - 2008-02-15 05:35:45
|
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 the client part is koi8-r or windows-1251. I use Postgres 8.1 and 8.2, psycopg 2.0.5, 2.0.6... Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: Max A. <max...@gm...> - 2008-02-18 01:57:08
|
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 <ph...@ph...> wrote: > 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 the client part is koi8-r or windows-1251. > > I use Postgres 8.1 and 8.2, psycopg 2.0.5, 2.0.6... > > > Oleg. > -- > Oleg Broytmann http://phd.pp.ru/ ph...@ph... > Programmers don't die, they just GOSUB without RETURN. > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > sqlobject-discuss mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss > |