Re: Funny Select

Posted in 1997

David Williams — Fri, 21 Feb 1997 20:23:59 +0000 — source: Informix-list mailing list archive (1991-1998)

In article <5eibc1$or5@panix.com>, Don Simon <ds5419@panix.com> writes >Patrick Preuss (ppr@deckard.hb.north.de) wrote: >: Hi, > >: how is it possible, that >: select * from x where x.a = '' >: has the same result as >: select * from x where x.a = ' ' >: and x.a consists of blanks? > >In informix '' is not the same thing as NULL, when comparing text Not in Informix SQL but in Informix 4GL they ARE the same. (Only applies to chars). >fields, they are assumed CLIPPED, so ' ' clipped is '', which is NOT >the same as the keyword NULL. > >I think that was the question you were asking, > > -- David Williams