[database] [Database] Toward better databases

Joshua D. Drake jd at commandprompt.com
Tue Jul 8 15:10:49 UTC 2008



On Mon, 2008-07-07 at 23:36 -0500, David Timothy Strauss wrote:
> Unless we're trimming the values, '' != ' ' != '  ' != '   '. I don't see the problem.

Obviously. 

It is generally not a good idea to have a blank, padded blank etc.. as a
potential for a primary key. It is probably a good idea to add a check
constraint to ensure that there is actually meaningful and contextual
data in the column.

Please do not top post.

Joshua D. Drake




More information about the Database mailing list