Cant get VARCHAR column to maximum size

[Indrek Võitra]

Hello!

I am migrating from 1.2 to 2.1 and want to avoid using BLOBS and migrate one column to varchar type.

H2 documentation mentions:

The allowed length is from 1 to 1,000,000,000 characters. 

Data stored in this field is  usually not very long, but in some very rare occations they can be up to 2 million characters.

Whatever i do, i cant get over 1048576  limit when creating table with character varying.

Precision ("10000000") must be between "1" and "1048576" inclusive; SQL statement:

Is there flaw in documentation or i do something wrong?

Indrek

[Evgenij Ryazanov]

Hello.

Online documentation is actual only for the latest released version, currently it is 2.1.214. If you use some older version, you need to download its complete distribution in a ZIP archive, it includes documentation in HTML and PDF formats:

https://h2database.com/html/download-archive.html

In H2 2.0.202–2.1.210 limit was 1,048,576 characters.

[Indrek Võitra]

Thanks a lot!

I had 2.1.210.