Re: IS NULL Question

[Baron Schwartz]

Jerry Schwartz wrote:
> We use NULL all the time with MyISAM tables, and I've never noticed a
> problem.

I think there was a bug at one point dealing with NULL and empty 
strings, but it strikes me that it was a bug in the new client/server 
protocol that was introduced in (4.1? 5.0?).

So, it might be that the columns contain empty strings, yet the client 
displays them as NULL.

Regardless, the earlier suggestion about using length() should show 
what's really in the columns.

Baron