From: Martijn Tonies
Date: February 23 2005 1:36pm
Subject: Re: UNIQUE Key Allowing Duplicate NULL Values
List-Archive: http://lists.mysql.com/mysql/180438
Message-Id: <03d701c519ac$af596d70$3802a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Tim,

> Oh well, thanks anyhow.
>
> If I could put in a feature suggestion, it would be a flag that I could
> set to disallow duplicate nulls.  :)

What for?

NULL is not equal to NULL. Period.

If you don't want NULLs, make the column "not null".

The specification is correct.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com