<p>Have you tried using the lower/upper/camel case instructions in PHP to make MySQL see what you want?</p>
<p>Jolly confusing how it all seems to contradict itself.</p>
<p><blockquote type="cite">On 24 Jun 2010 13:39, "Mike Tipping" <<a href="mailto:mike@etuna.co.uk">mike@etuna.co.uk</a>> wrote:<br><br>Whenever I run a select in Mysql based on a string comparison, the<br>
comparison is always case sensitive so where 'name' in the DB is 'mike',<br>
select * from table where name = 'MIKE'; won't return results.<br>
<br>
Looking at the MySQL documentation it says that case sensitivity on<br>
comparisons depends on the collation and if I use 'latin1_swedish_ci' (which<br>
I do) the comparison will be case insensitive (which it isn't).<br>
<br>
It also says that STRCMP() is by default case insensitive, but when I try<br>
that it still doesn't return anything.<br>
<br>
Any ideas what I might be doing wrong or what I can use to do a case<br>
insensitive string comparison in MySQL.<br>
<br>
Cheers<br>
<br>
Mike<br>
<br>
<br>
<br>
_______________________________________________<br>
Phpwm mailing list<br>
Website : <a href="http://www.phpwm.org" target="_blank">http://www.phpwm.org</a><br>
Twitter : <a href="http://www.twitter.com/phpwm" target="_blank">http://www.twitter.com/phpwm</a><br>
Facebook: <a href="http://www.facebook.com/group.php?gid=2361609907" target="_blank">http://www.facebook.com/group.php?gid=2361609907</a><br>
<br>
Post to list: <a href="mailto:Phpwm@mailman.lug.org.uk">Phpwm@mailman.lug.org.uk</a><br>
Archive etc : <a href="https://mailman.lug.org.uk/mailman/listinfo/phpwm" target="_blank">https://mailman.lug.org.uk/mailman/listinfo/phpwm</a><br>
</blockquote></p>