[sqlalchemy] Re: Exception raised on insert blob.

2007-05-25 Thread Mike Bernson
moving to mysqldb 1.2.1-p2 fixed the problem. It was a mysqldb issue. Just a note this is the standard setup for ubuntu dapper. We use the LTS version of unbuntu on server and client matchines. We might want something in the faq about min version of mysqldb or note about known broken version of

[sqlalchemy] Re: Exception raised on insert blob.

2007-05-25 Thread jason kirtland
FYI the MySQLdb 1.2.1 gammas 1 through 3 seem to have this blob issue. 1.2.1 and 1.2.2 final are both OK. Mike wrote: > > will try one a few systems and different MYSQLdb > > The mysqlDB 1.2.1gamma3 > > __author__ = "Andy Dustman <[EMAIL PROTECTED]>" > __revision__ = """$Revision: 1.36.2.4 $"""[

[sqlalchemy] Re: Exception raised on insert blob.

2007-05-24 Thread Mike Bernson
will try one a few systems and different MYSQLdb The mysqlDB 1.2.1gamma3 __author__ = "Andy Dustman <[EMAIL PROTECTED]>" __revision__ = """$Revision: 1.36.2.4 $"""[11:-2] version_info = ( 1, 2, 1, "gamma", 3) will do some more testing on friday afternoon. Michael Bayer

[sqlalchemy] Re: Exception raised on insert blob.

2007-05-24 Thread Michael Bayer
On May 24, 2007, at 10:12 PM, Mike Bernson wrote: > It give me an error attaching output well that tests passes for everyone else AFAIK, so maybe something is up with either the way youre connecting to MySQL (are you turning on the use_unicode flag? ) or maybe your version of MySQLDB, what

[sqlalchemy] Re: Exception raised on insert blob.

2007-05-24 Thread Michael Bayer
hey mike- what happens when you run the testtypes.py unittest ? python test/sql/testtypes.py BinaryTest --log-debug=sqlalchemy.engine --dburi mysql://user:[EMAIL PROTECTED]/db On May 24, 2007, at 8:41 PM, Mike Bernson wrote: > > I also just tried using a blob to replace longblob as blob

[sqlalchemy] Re: Exception raised on insert blob.

2007-05-24 Thread Mike Bernson
I also just tried using a blob to replace longblob as blob is in the list of types for mysql and longblob was not. I get the same error Mike Bernson wrote: > I am trying to insert binary data (PDF) into the follow table in mysql > 5.0.22 using python 2.4 and SQLAlchemy 3.7. > > I get exception