Fix handling of large varbinary for SAP/Sybase ASE

Description

In ASE, the VARBINARY type has max size equal to the pagesize.
https://wiki.ispirer.com/sqlways/sybase/data-types/varbinary

When a VARBINARY type is requested that is longer than the max size, we should use the IMAGE type instead:
https://wiki.ispirer.com/sqlways/sybase/data-types/image

This should mirror the behaviour of other Transact SQL dialects such as SQLServerDialect:
https://github.com/hibernate/hibernate-orm/blob/master/hibernate-core/src/main/java/org/hibernate/dialect/SQLServerDialect.java#L42

Activity

Show:

Gavin King November 23, 2024 at 7:36 AM
Edited

This issue was mostly, but not perfectly, already addressed in Hibernate 6.0.

As of H7, SybaseASEDialect will now query the @@maxpagesize at startup. This was something I've been meaning to implement for a while. It's done now.

Fixed

Assignee

Reporter

Fix versions

Priority

Created April 22, 2020 at 9:39 PM
Updated 6 hours ago
Resolved November 23, 2024 at 7:36 AM
Loading...