[dev] Horde_Db and text fields

Chuck Hagenbuch chuck at horde.org
Tue Dec 6 14:59:28 UTC 2011


Quoting Michael J Rubinsky <mrubinsk at horde.org>:

> There was a recent ActiveSync related bug  
> (http://bugs.horde.org/ticket/6601) the brought database field  
> length issues to my attention. In MySQL, the 'text' field is limited  
> to 64k, while it is essentially unlimited in PostgreSQL, and in  
> SQLite, by default, is around 2GB.
>
> MySQL has additional text fields with larger limits. Does it make  
> sense to add support for those additional fields to the various  
> Schema objects? Obviously for RDBMS other than MySQL, they would  
> simply be aliases to the 'text' field...

Yes, similar to some of the integer field sizing code. I think that  
makes sense.

-chuck


More information about the dev mailing list