error version 2.0.204

[Rafael Simón Vera Urdaneta]

ERROR: Value too long for column "CHARACTER VARYING":

[Evgenij Ryazanov]

Hello.

H2 2.0 allows up to 1048576 characters for this data type:

https://h2database.com/html/datatypes.html#character_varying_type

For larger values you need to use CLOB:

https://h2database.com/html/datatypes.html#character_large_object_type

Please note that PreparedStatement.setString() and ResultSet.getString() cannot be used to set or read large CLOB value. You need to use methods with java.sql.Clob or java.util.Reader / java.util.Writer.