Re: Primary Key Constraint Problem

2003-09-25 Thread Victoria Reznichenko
"Jacques Buitendag" <[EMAIL PROTECTED]> wrote: > > I have recently discovered that when you place a primary key constraint on a column > of type CHAR(2) the constraint causes the following to happen when I add a new row > to the table: > > if a key ("AA") is already in the table then I can not

Primary Key Constraint Problem

2003-09-25 Thread Jacques Buitendag
Hi All, I have recently discovered that when you place a primary key constraint on a column of type CHAR(2) the constraint causes the following to happen when I add a new row to the table: if a key ("AA") is already in the table then I can not add "Aa", "aA" or "aa" this seams a bit wrong as