CODEWITHSUNDEEP
.netsqlinformix
Anyname Donotcare
Anyname Donotcare

Reputation: 11393

Why can't I update TEXT type columns in Informix

I face the following problem. I have some fields in my Informix database. I decided to change these fields to TEXT type (BLOB) to allow large text. The problem is: when inserting new values, it works perfectly, but the problem when updating existing values is it doesn't work at all. What is the problem?

Upvotes: 1

Views: 1201

Answers (1)

Costis Aivalis
Costis Aivalis

Reputation: 13728

Maybe you should give a try with the CLOB datatype instead of BLOB, since you have text data. CLOB stands for Character Large OBject and BLOB for Binary Large OBject.

Upvotes: 1

Related Questions