[h2] Re: Cant get VARCHAR column to maximum size

2022-09-13 Thread 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.

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/efc8e42b-9f14-4aa9-a238-91727e229e1dn%40googlegroups.com.


[h2] Cant get VARCHAR column to maximum size

2022-09-13 Thread 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 ("1000") must be between "1" and "1048576" inclusive; SQL 
statement: 


Is there flaw in documentation or i do something wrong?

Indrek

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/55758ea4-4fdd-48e3-81fe-6ef320dacc0dn%40googlegroups.com.


[h2] Keycloak H2 database migration to RDS Posgtres RDS

2022-09-13 Thread Ananda Bose
Hello ,

I have Keycloak H2 database which I want to migrate(import and export) to 
AWS RDS Postgres database. Can anyone please let me know steps how to 
achieve it.

Regards,
Ananda

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/61d8c329-48f9-4dcc-9c0c-54bd4e78de43n%40googlegroups.com.