Native storage
UUID has native support in the following database platforms:
- H2
- Postgres
- SQL Server 17
When using these database platforms UUID is stored in a native manor.
Binary storage
Stored as BINARY(16), has the option of storing in optimised manor meaning the order of bytes is changed to provide a better distribution in index.
Varchar storage
Stored as VARCHAR(40).
DatabaseConfig.setDbUuid()
When the database platform does not support UUID natively we can configure the
storage option via DatabaseConfig.setDbUuid(...)