Hi, We are using Firebird database, and some of the columns for text are blob subtype binary. Now we have a problem with how to say this to Hibernate. I tried: @Lob @Column(length=Integer.MAX_VALUE-1) private String note; This code throws Schema-validation: wrong column type encountered in column…

Thanks for your reply and advice. I added to the Firebird dialect: @Override public boolean equivalentTypes(int typeCode1, int typeCode2) { if(isStringType(typeCode1) && isStringType(typeCode2)) return true; return super.equivalentTypes(typeCode1, typeCode2); } …

Mapping binary blob to string

Hibernate ORM

trueMiskin June 5, 2025, 12:07pm 8

@mrotteveel now is the question, how to fix it? Will be sufficient to just add a new blob text column, transfer data from the binary blob, and remove the old column? Will there not be a problem with encoding after that?

Topic		Replies	Views
Hibernate Convert String Values to Varbinary and try insert as Hexa decimal Hibernate ORM	1	262	May 27, 2024
6.5: what jdbc type for SchemaUpdate to generate text column on PostgreSQL Hibernate ORM	5	284	July 31, 2024
How can i force hibernate to save ipBytes as BINARY type? Hibernate OGM	1	1192	January 21, 2019
How to map byte[] to jdbc BINARY type? Hibernate ORM	1	3848	February 10, 2018
Mapping String to JSON PG and CLob Oracle - rs.getBytes error Hibernate ORM	1	591	October 13, 2023

Mapping binary blob to string

Related topics