> -----Original Message----- > From: Lothar Scholz [mailto:[EMAIL PROTECTED] > Sent: Friday, January 18, 2008 3:50 PM > To: [email protected] > Subject: [sqlite] Is there a difference between NULL und zero > byte length BLOB/TEXT? > > Hello, > > The last question for today: > Is there a difference between NULL und zero byte length BLOB/TEXT? > > Need this information for my SQLite GUI Frontend.
In my mind, yes. An equality test against two empty blobs will result in a match. A test of two NULL's will not -- nor will a test of a NULL vs. empty blob. So there is a difference between NULL and an empty blob. Robert ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
