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 this is undesireable, add 'binary' modifier after char:
words char(32) binary default '0' not null
--
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)
