MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Mark Maggelet Date:September 16 1999 11:37am
Subject:case insensitive? not for me.
View as plain text  
all the documentation I've read says that a select on a varchar is case
insensitive, so who do

select * from person where locate("James",firstname)<>0

and

select * from person where locate("james",firstname)<>0

give me different results? (the first finds 'James', the second doesn't)


Thread
case insensitive? not for me.Mark Maggelet16 Sep
  • Re: case insensitive? not for me.James Manning17 Sep
  • Re: case insensitive? not for me.Martin Ramsch17 Sep