Sounds good!
Will you change it?
Thanks,
Oliver
Jacob Lund wrote:
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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
