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 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
-------------------------------------------------------------------------
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
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
