At 16:23 -0500 4/4/03, <[EMAIL PROTECTED]> wrote:
Now when i put data into the table i can't have all blanks which is right. When i put data into the field that allows nulls the not null one gets '' as its data and goes on. I though NULL and '' were the same thing. Am i nuts?
I don't know if you're nuts or not, but NULL and the empty string are very definitely not the same thing.
If Michael's nuts, he's in popular company. Some RDBMS's *do* treat NULL and the empty string as the same thing (although I personally think it's wrong to do so). In particular, I've heard of one RDBMS whose name begins with O and ends in E and has the letters R, A, C, and L int he middle, which does it this way. Other RDBMS's, such as OpenIngres (the one I'm personally most familiar with) distinguish between the two, as MySQL does.
But I certainly understand his confusion!
Bruce Feist
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
