Primary Key Constraint Problem

[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 'A' != 'a' in the representation of CHAR 

Is this the way that primary key constraints are specified in ANSI SQL ? and is there 
a way of inserting "AA" and "aa"
Kind Regards
Jacques Buitendag