Re: Why does unique treats the letter "a" as "A" and vise versa?

[Jim Faucette]

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...