[dev] Horde_Db and text fields

[Michael J Rubinsky]

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...

Otherwise, I don't see any portable way to adjust the field length  
using migrations on MySQL. Or am I overlooking something?
-- 
mike

The Horde Project (www.horde.org)
mrubinsk at horde.org