I am building a application which will accept a variable sized string
input as one of my columns and I have already had cases where the
maximum size of 65536 for a MySQL 'text' column was too small and the
data is being truncated. I am having a problem trying to coerce
sqlalchemy into using a longtext column type with my backend MySQL
database. I have tried the following with my Table definition: (2^32)
Column('data', Text(4294967296), nullable=False)
and it continues to define the column as a 'text' type. Only when I
use:
Column('data', MSLongText(), nullable=False)
does it actually create my table with the longtext column.
I would like to be DB agnostic and avoid using the MySQL specific
MSLongText type if possible. What am I missing?
Thanks,
Jon Miller
sqlalchemy version 0.5.0rc4
mysql version 5.0.67
python 2.5
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
