Long string data type in H2 database

Question

I am trying to create an H2 database to manage some text clippings. One of the fields will contain a large string, which can be hundreds, and in several cases, thousands of words.

Ideally, I would not want to limit the size of this field at the time the table was created; it would be better if it was dynamic, but if this is not possible, you will want to highlight generously so that the text is not cut. Any suggestions on how to implement this? Is VARCHAR (10000) possible? psycho? Thank you

Answer 1

You can use the CLOB data type. Take a look at the page