Re: [h2] Compatibility issues when downgrading H2 database from v2.1.214 to v1.4.196

2023-06-10 Thread 'Christian Buchegger' via H2 Database
I remember some post on this list or on the bugtracker saying that there is no support for going back. The options are either edit the exported sql to match the old syntax of do a date export/import using other tools avaible into an empty schema on the old version. -- You received this message be

[h2] Compatibility issues when downgrading H2 database from v2.1.214 to v1.4.196

2023-06-06 Thread Niv F
Hi, We cannot import an SQL script file, which was exported from an H2 v2.1.214 database, to H2 v1.4.196 database. It seems that the issue is with the *CHARACTER VARYING* & *CHARACTER LARGE OBJECT* data types, which are not recognized in H2 v1.4.196. Has anyone encountered this issue? Is there