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]



Reply via email to