List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:June 7 1999 6:09pm
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 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)
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