Think of NULL as "value is unknown". With zero length blob/text, value is known: 0-length blob/text
Cheers, Mark > -----Original Message----- > From: Zbigniew Baniewski [mailto:[EMAIL PROTECTED] > Sent: Friday, January 18, 2008 4:51 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] SQLite character comparisons > > On Fri, Jan 18, 2008 at 02:13:51PM -0800, Darren Duncan wrote: > > > Don't read too much into that statement; I'm was not raising the > > auto-trim thing. > > Yes, yes - I know... "Roma locuta"... > -- > pozdrawiam / regards > > Zbigniew Baniewski > > -------------------------------------------------------------- > --------------- > To unsubscribe, send email to [EMAIL PROTECTED] > -------------------------------------------------------------- > --------------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------