Subject Unable to SELECT a BLOB column... or fix it...
Author fsalait
I have a bad problem with a table in my db.
This is a car database accessed through PHP web pages that worked
perfectly over last 15 months.
Yesterday, we started to have an error when looking to that page:
"arithmetic exception, numeric overflow, or string truncation" when
reading any row from the MYCARS table (with PHP's ibase_fetch_object
function).

I inspected that table with IBExpert, QuickDesk and so on and I get
the same error when trying to get the rows inside ("Data" slip on
Table window, SELECT query... and similar tests)

GBak refuses to backup database, GFix says everything is ok.

CREATE TABLE MYCARS (
[...]
DESCR BLOB SUB_TYPE 1 SEGMENT SIZE 100,
[...]
);

Later, I copied the .gdb file and I dropped DESCR column (the only
one with a BLOB) and I haven't errors anymore.... but I need the
text stored in that column!! :-)

Can somebody help? DB is not so high (less than 1Mb), so... if
somebody wants to have a look... let me know...

Thanks in advance

Fabrizio Sala
Como, Italy