H2 CLOB type is generated as VARCHAR


Column type CLOB is created as VARCHAR in H2 for some reason. How could I force it to proper type? Using Liquibase 2.0.3.

Hi,

I have the same problem. For both generic types TEXT and CLOB there is called TypeConverter.getClobType() in AbstractTypeConverter.getDataType(). I would expect:

  • TEXT -> getTextType()
  • CLOB -> getClobType()

H2TypeConverter.getTextType() would create a CLOB instead of a LONGVARCHAR. For me it looks like a bug.

Regards
Stefan