A couple options: - You could create a subclass of the MySqlDatabase class and override the getClobType() method. You can pass the databaseClassName into liquibase. - You could also specify the type as a parameter: <column type="${clobType}"/> and then pass the value into liquibase.
I would think that either option would be easier than having to use contexts because contexts would require you to duplicate your changesets except for the clob type. If there aren't a lot of tables being created, however, the context (or "dbms" attribute) route may be the easiest. Nathan -----Original Message----- From: David C. Hicks [mailto:dhi...@i-hicks.org] Sent: Monday, March 16, 2009 11:01 AM To: Liquibase Users Subject: [Liquibase-user] CLOB vs. LONGTEXT Hi folks, Making some headway on setting up in-memory, test databases, but I've encountered a "type" problem. We currently define a couple of columns as the type LONGTEXT, because we anticipate storing really large strings of data. If I understood my reading of the Liquibase docs, it is preferred to use CLOB in order to keep the XML compatible across multiple databases. Unfortunately, CLOB creates a regular TEXT field in MySQL, thus reducing the size to 64k - yes, our data could be larger than that. So, I'm wondering if there is a good way to handle this? Perhaps this is another good use of the "context" attribute on a changeset - so that one datatype is used for production and another is used for testing? While not ideal, it would work. I just wanted to try to get a "best practice" opinion. Thanks, Dave ------------------------------------------------------------------------ ------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ Liquibase-user mailing list Liquibase-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/liquibase-user ------------------------------------------------------------------------------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ Liquibase-user mailing list Liquibase-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/liquibase-user