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).


When the database platform does not support UUID natively we can configure the storage option via DatabaseConfig.setDbUuid(...)