While working on HHH-12834, it has become clear that the support for Clob, Blob, NClob, and NBlob types in can be problematic, particularly when an element-collection is in play such as
From the Envers perspective, mappers and initializors tend to build queries using properties regardless of their data types. This leads to issues for data types such as clob and blob where certain database platforms only support a limited subset of predicates against those column types.
For example, Sybase only allows LIKE and IS [NOT] NULL predicates on clob columns. This in particular leads to issues with the QueryGenerator implementions interating with mappers to initialize lazy collections, etc.
A great example is StringMapNationalizedLobTest which was highlighted as a problem in HHH-12834. We temporarily disabled the test because the underlying problem goes deeper than dealing with the translation of CLOB to UNITEXT for Sybase.