Interesting outcome in the discussion with Evgenij, H2 accepts NVARCHAR but doesn't directly support it. You can use it in H2 DDL though, will just be converted to VARCHAR.

Wondering if it would be better to use "VARCHAR" as local type name in our custom JDBC type above?