Simple enough Blob is a binary type, not a character type. You need to
put binary data in there, so in python 2x that's str, ie encode it. Direct
Unicode support in sqla is via the string/Unicode types.
Sent from my iPhone
On Nov 29, 2010, at 8:43 PM, Warwick Prince
we've got unicode round trips down very well for years now with plenty of
tests, so would need a specific series of steps to reproduce what you're doing
here. Note that the recommended connect string for MySQL + Mysqldb looks like
mysql://scott:ti...@localhost/test?charset=utf8use_unicode=0 .
Hi Michael
Thanks for your thoughts and comments to date.
I can replicate the problem with ease, so perhaps this will help;
# -*- coding: utf-8 -*-
e =
create_engine('mysql+mysqlconnector://user:passw...@127.0.0.1/testdb?use_unicode=0',
encoding='utf8', echo=False)
m = MetaData(e)
t =
Hi All
I thought I had Character Encoding licked, but I've hit something I can't
work through. Any help appreciated.
I have a legacy non SQL database that I read legacy data from (using cool
Python code that emulates the old ISDB binary comms) and it reads a str which
has Foreign language
