I have noticed that when using the C API that in certain instances
the field 'type' constant is not correct.
When a value is returned from a 'TEXT' type field it is reported as a
'BLOB' type. I realize that a TEXT is an extension of a BLOB, but,
since they are different types according to
I am trying to find records where the value of a filed is NULL. I
know that there are records that have null values but the result is
always an empty set.
eg:
select test_id from tests where test_id=NULL
always returns an empty set when there are in fact records that have
a null value
On Oct 30, 2006, at 3:27 PM, Jay Blanchard wrote:
[snip]
I am trying to find records where the value of a filed is NULL. I
know that there are records that have null values but the result is
always an empty set.
eg:
select test_id from tests where test_id=NULL
always returns an empty set