Text Column Cannot be Inserted

[redijedi]

I have an MS SQL table with a text datatype column. Every time I try to persist my object it fails and I get "Operand type clash: varbinary is incompatible with text" exception. I've read that using the @Column(columnDefinition = "clob") or @Column(columnDefinition = "text") in my entity defination will work, but it doesn't. I've also read that setting the columnlength up will help, but it didn't.

Is this a bug? Is there any way around this?

Thanks
T

[redijedi]

Also tried @Lob...doesn't work.

[redijedi]

Also, it only happens when the property is null. Otherwise, it will accept the text data with no trouble. If it's nulled out, it fails. The column allows nulls, so its not a db problem. It seems as the hibernate is trying to set the column data to varbinary when the property is null which is incompatible with mssql. This seems like a bug.

[redijedi]

As a work around, I've had to set null text columns to "", but that's a hack. If anyone has any insight into this, please let me know. Otherwise, I'll file a bug report.