Hello. We're using MySQL 4.1.x and have one table (currently) in our
application that's responsible for holding binary data.
>From my understanding, the maximum length of the BLOB column in MySQL
4.1 is limited to 64k, which is a little too small for comfort. But
that seems to be all that is supported as of SQLAlchemy 0.2.6. I was
able to add a MEDIUMBLOB to our own `tables.py` module easily enough.
But I was wondering - is there any reason these aren't supported? I
see there's support for `MEDIUMTEXT BINARY` in the databases.mysql
module, but I haven't been able to get understandable answers out of
the MySQL 4.x docs about whether `MEDIUMTEXT BINARY` === `MEDIUMBLOB`.
Should I continue using my own type for our purposes, or is
MSMediumText(binary=True) safe to use?
class MEDIUMBLOB(mysql.MSBinary):
def get_col_spec(self):
return "MEDIUMBLOB"
Thanks,
Jeff Shell
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
