[Sqlalchemy-tickets] Issue #3284: sqlalchemy-monetdb, python2 and unicode (zzzeek/sqlalchemy)

[Gijs M. <iss...@bi...>]

New issue 3284: sqlalchemy-monetdb, python2 and unicode
https://bitbucket.org/zzzeek/sqlalchemy/issue/3284/sqlalchemy-monetdb-python2-and-unicode

Gijs Molenaar:

Hi!

I'm about to release sqlalchemy-monetdb 0.9 but I have one final bug that I just don't can't manage to squash for a while now. I just don't understand where the problem lies, if it is a problem with sqlalchemy-monetdb (0.9) or python-monetdb.

problem is where you have a utf-8 encoded unicode string in a source file which is inserted into the database using sqlalchemy. Somehow the fetched results differ. Only happens with Python2, not python3. Probably it is a very stupid misunderstanding of how utf-8 encoded strings are handled somewhere. 

see test output here:

https://travis-ci.org/gijzelaerr/sqlalchemy-monetdb/jobs/44208224

If you don't have a simple suggestion then never mind, I probably need to dive into python2 and unicode handling again.