similar to something we just did with MSSQL regarding Binary, we'd
need to add a MSGenericText type that issues any number of TEXT types
when asked for DDL, based on the length present.
On Jan 7, 2009, at 10:31 AM, jonEbird wrote:
>
> 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
-~----------~----~----~----~------~----~------~--~---
