The TEXT type has a 64K limit, the MEDIUMTEXT has a16MB limit and LONGTEXT has a 4GB limit!
MEDIUMTEXT should be enough, but will TEXT do as default in the MySQL scheme? /jacob ----- Original Message ----- From: "Luke Noel-Storr" <[EMAIL PROTECTED]> To: "Slide Users Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, May 19, 2004 11:15 AM Subject: Re: Could not parse DAV:version-set: > Carlos Villegas wrote: > > > Some databases like PostgreSQL have a type TEXT with unlimited length. > > We only need to change the type in the schema, the DB adapter doesn't > > have to be changed. For databases that don't have a similar type, I > > guess a BLOB will be one way. > > > MySQL also has a TEXT type (and LONGTEXT, MEDIUMTEXT, etc). It's not of > unlimited length, but a LONGTEXT field can be up to 2^32 characters > long, I guess the version history would need to be pretty damn long to > exceed that. > > I've tried changing the field to a TEXT filed and it seems fine, can > anyone see any potential problems with this approach? > > > Cheers > > Luke. > ----- > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
