Re: [sqlite] UNIQUE Constraint but case sensitive

2005-06-24 Thread Dan Kennedy 

 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 the 26
letters used in the English language.





__ 
Yahoo! Mail 
Stay connected, organized, and protected. Take the tour: 
http://tour.mail.yahoo.com/mailtour.html

[sqlite] UNIQUE Constraint but case sensitive

2005-06-23 Thread Ajay 









 
  
  
  
  
  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