Toad World® Forums

Query hangs on NULL value in BLOB column using Firebird ODBC

I have never been able to run SELECT statements that includes a BLOB column using TDA, and now TDP, with the Firebird (Interbase) ODBC driver. I discovered today that it seems to work fine as long as there is a value in the BLOB column, but once it tries to read a NULL or 0 length BLOB value the query hangs. Please see screenshot: