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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
