List:General Discussion« Previous MessageNext Message »
From:Jim Faucette Date:June 7 1999 6:24pm
Subject:Re: Why does unique treats the letter "a" as "A" and vise versa?
View as plain text  
kenford@stripped wrote:
> 
> Why does unique treats the letter "a" as "A" and vise versa?
> It does not seems to recognize case-sensitive words.
> 
> CREATE TABLE list (
> words_id                int(7) default '0' not null auto_increment,     # 1,2,3
> words                   char(32) default '0' not null,                  # Aviation
> Biology
> unique                  words (words),
> key                     words_id(words_id),
> index                   word_index(words)
> );

If you want words to be case sensitive use the binary keyword:
  words char(32) binary default '0' not null, 
  
  jim...
Thread
Why does unique treats the letter "a" as "A" and vise versa?kenford7 Jun
  • Re: Why does unique treats the letter "a" as "A" and vise versa?Sasha Pachev7 Jun
  • Re: Why does unique treats the letter "a" as "A" and vise versa?Jim Faucette7 Jun