Re: [sqlite] UNIQUE Constraint but case sensitive

Hi, I need to create a unique constraint on a column of type varchar, but it is not case sensitive by default. Does any one know how to make a unique constraint case sensitive? CREATE TABLE abc(a UNIQUE COLLATE NOCASE); Bear in mind that the NOCASE collation sequence only knows about

[sqlite] UNIQUE Constraint but case sensitive

Hi, I need to create a unique constraint on a column of type varchar, but it is not case sensitive by default. Does any one know how to make a unique constraint case sensitive? Thanks and best regards, Ajay Sonawane