While working on HHH-12834 Resolved , 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

@ElementCollection
@Lob
@Nationalized
private Map<String, String> values;

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 Resolved . We temporarily disabled the test because the underlying problem goes deeper than dealing with the translation of CLOB to UNITEXT for Sybase.