Hello. Where did you find that syntax? There are no unsigned numeric data types in the SQL Standard and in the most of database systems including the H2. This is a feature of MySQL. H2 silently accepts UNSIGNED only in MySQL and MariaDB compatibility modes, but this declaration is ignored by H2 anyway. https://h2database.com/html/features.html#compatibility Also the real MySQL doesn't have the ARRAY data type, so if you use H2 as an replacement of MySQL for unit tests, you shouldn't try to use it.
If you use H2 as a primary database, you can use standard-compliant ARRAY data type safely: https://h2database.com/html/datatypes.html#array_type You cannot declare your column as UNSIGNED, but you can add a check constraint to it if you wish. -- 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/73bf3449-81ac-415e-b749-7ffdef344489n%40googlegroups.com.