CAST: when converting a string to binary, it is hex encoded (every byte two characters); a hex string can be converted to a number by first converting it to binary.

MS SQL Server compatibility: support string literals prefixed with N ("National Language" strings). Issue 240.

CAST('011' AS INT) will no longer use decode the value as an octal number (using Integer.decode) but now use Integer.parseInt. The same logic applied to byte, short, and long.

When a domain (user defined data type) contained a user defined function, the database could not be opened.

The LOB storage (when the system property h2.lobInDatabase is set) is now only initialized when needed.

The LOB storage (when the system property h2.lobInDatabase is set) is now only initialized when needed.

Temporary files were not created in the temporary directory of the system, but in the current working directory.