Hi,
using MySQL in an entirely utf8-environment I got the following:
class Testtable(ActiveMapper):
class mapping:
pkey = column(Unicode(10), primary_key=True)
test = column(Unicode(4))
sqlalchemy.dburi="mysql://test:[EMAIL PROTECTED]/testdb?use_unicode=1"
MySQLdb.__version__
1.2.1_p2
>>> t = Testtable.selectone()
>>> t.test
u's\xfcd'
>>> print t.test
süd
>>> s = t.test
>>> s = s + '!'
>>> print s
süd!
>>> t.test = s
>>> session.flush()
2006-12-12 16:07:36,684 INFO sqlalchemy.engine.base.Engine.0x..b4 BEGIN
2006-12-12 16:07:36,684 sqlalchemy.engine.base.Engine.0x..b4 INFO BEGIN
2006-12-12 16:07:36,686 INFO sqlalchemy.engine.base.Engine.0x..b4 UPDATE
testtable SET test=%s WHERE testtable.pkey = %s
2006-12-12 16:07:36,686 sqlalchemy.engine.base.Engine.0x..b4 INFO UPDATE
testtable SET test=%s WHERE testtable.pkey = %s
2006-12-12 16:07:36,687 INFO sqlalchemy.engine.base.Engine.0x..b4
['s\xc3\xbcd!', 'first']
2006-12-12 16:07:36,687 sqlalchemy.engine.base.Engine.0x..b4 INFO
['s\xc3\xbcd!', 'first']
/usr/lib/python2.4/site-packages/SQLAlchemy-0.3.1-py2.4.egg/sqlalchemy/engine/default.py:64:
Warning: Data truncated for column 'test' at row 1
2006-12-12 16:07:36,692 INFO sqlalchemy.engine.base.Engine.0x..b4 COMMIT
2006-12-12 16:07:36,692 sqlalchemy.engine.base.Engine.0x..b4 INFO COMMIT
>>> s
u's\xfcd!'
However, this is used by SA during update:
>>> s.encode('utf8')
's\xc3\xbcd!'
Is this "double encoding" due to "use_unicode=1" on SQLAlchemy, or is it
a MySQLdb problem? Or any problem between my ears??
When I do it on pure MySQLdb, everything works fine. Not surprisingly,
because I explicitly say:
cursor.execute("update testtable set test=%s", s)
having s as given above (only one row, no where-clause needed).
TIA,
Stefan
--
Start here: www.meretz.de
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
