Alexander V.Nevsky wrote:

>--- In firebird-support@yahoogroups.com, Jonathan Neve <jonathan@m...>
>wrote:
>
>
>>Martijn Tonies wrote:
>>
>>
>>
>>>You're answering your own question: '' (empty string) is NOT NULL.
>>>NULL is NULL (empty). An empty string is a value. NULL is a state,
>>>so is "NOT NULL".
>>>
>>>
>>>
>>IMHO, this unique feature could nearly be considered a bug...
>>
>>
>
> In SQL standard? ;)
>
>

Absolutely! A bug in that it defines a useless distinction that would
forever be a nuisance for every database developer! :-)

Jonathan Neve.


[Non-text portions of this message have been removed]