[GENERAL] unique key issue

HI I have a table with a unique key constraint on col1,col2. The dattabase allowed an multiple inserts. here is how col1 col2 'abc' empty space 'abc' empty space I am not sure how this can happen ---(end of

Re: [GENERAL] unique key issue

Junkone wrote: HI I have a table with a unique key constraint on col1,col2. The dattabase allowed an multiple inserts. here is how col1 col2 'abc' empty space 'abc' empty space I suppose the values in col2 are NULL values? You cannot compare NULL values. NULL ==

Re: [GENERAL] unique key issue

On Mon, Sep 18, 2006 at 03:54:05PM -0700, Junkone wrote: HI I have a table with a unique key constraint on col1,col2. The dattabase allowed an multiple inserts. here is how col1 col2 'abc' empty space 'abc' empty space Depends on what you mean by empty space. If