[Monetdb-developers] encoding of strings returned by Python client
mkbucc at gmail.com
Tue Dec 22 13:43:25 CET 2009
On Tue, Dec 22, 2009 at 5:30 AM, Gijs Molenaar <gijs.molenaar at cwi.nl> wrote:
> Do you know the behavior of other db API's?
MSQLdb has a use_encoding keyword.
The PostgreSql Django adapter had a set_client_encoding()
method on the connection object.
The native SQLite3 Python module just returns Unicode.
> How big is the problem to do a manual
> conversion to unicode in your wrapper?
Painful--I couldn't find a good place to hook
in the code.
> The problem is that there isn't a real standard
> way of doing this, at least not defined by the
> python db API 2.0.
Yup, the PEP is encoding agnostic.
I though the path you started down was a good
idea; pass a use_unicode keyword to the connection
Then if use_unicode = True, just decode("utf8") the
string in __strip(), otherwise leave code as is.
More information about the developers-list