Generating Changelog for MS SQL Server Types text and nvarchar(max) emit wrong types

Hi there!


In order to reproduce the error


  • Create a table that contains text and an nvarchar(max) column

  • Generate the Changelog using Liquibase


The Text column is generated as follows

The nvarchar(max) column is generated as 


It is possible to work around the Porblem usinge the modify tag.  


Thank you for a promising tool!

We get the column size directly from the database, and it gives us the size, not “max”. I created http://liquibase.jira.com/browse/CORE-1065 to watch for that value and convert it back to max


For now, you will have to use the modify tag, or just edit the generated xml directly.


Nathan