CHARACTER VARYING since H2 2.0 can hold only up to 1,048,576 characters, that's why text was remapped to CHARACTER LARGE OBJECT. There are two possible workarounds: CHARACTER VARYING(1000000) or ...