On 3/19/15, Paul <devgs at ukr.net> wrote: > Maybe this question was already asked and explained. > Or maybe it is documented somewhere (could not fiund it). > Sorry, if this is the case, but why does > > SELECT '' = x''; > > yields 0? >
Because it has never before occurred to the developers that somebody would compare a String to a Blob an expect them to be equal to one another. -- D. Richard Hipp drh at sqlite.org