[Mono-list] MySQL and NULL values

Derek Hamilton derek@capweb.com
Fri, 7 Feb 2003 15:35:05 -0800


Hello all,

I am using the ByteFX library for MySQL db access and am experiencing
trouble with NULL.  I am wondering if this is a MySQL problem (I remember
something about null handling being a problem in that past) or a BtyeFX/mono
problem.

Specifically, if I create a MySQLDataReader and Read() through the results
where the results all have values it works fine.  If I try reading through a
result set with any kind of NULL I get a "Object reference not set to an
instance of an object."

If I change all the nulls in my db to be an empty string the problem doesn't
occur.  I'm just not sure how feasible that is.

Any advice?

Thanks,
Derek Hamilton