> 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
> unique words (words),
> key words_id(words_id),
> index word_index(words)
if this is undesireable, add 'binary' modifier after char:
words char(32) binary default '0' not null