Hi,
We have a customer hosting on our Windows 2003 server and would like to know how to use case sensitive searching on their website? They are a professional photographer and have a huge library of photos that can be searched so this is an essential thing for them. I am no programmer, so if anyone has a solution then please can you give it to me in some kind of english :)
Many thanks in advance,
CNL24
Best way is to use a case sensitive collation in the db. If you don't want to edit the db then you'd need to make a code change each time you update Coppermine.
include/search.inc.php
find
if (in_array($param, $allowed))$fields[] = "$param LIKE '%$word%'";
change to
if (in_array($param, $allowed))$fields[] = "$param LIKE BINARY '%$word%'";