>> >> Kjell Rilbe wrote:
>> > Somehow it seems typical of a Microsoft product to do strange unexpected
>> > things without telling anyone... And I though other FB enthusiasts like
>> > me might find this example amusing. :-)
>>
>> Another amusing example is how MSSQL handles UNIQUE consraints with
>> NULLable fields compared to all others. ;-))
>
> Can you elaborate? I seem to recall that MSSQL allows only one NULL
> record for unique constraints?

Correct.

Is it more common to ignore nulls

> completely in unique constraint?

Yes. Although - AFAIK - things are a bit different when the unique
constraint/index is a compound one.

Or is it the other way around?

No.

And

> which one is more standard compliant?

AFAIK, ignoring NULLs, that said, treating NULL not as a value.


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/