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.

Reply via email to