Re: Case sensitive

Perhaps its a collatioon issue? Are you using the same characterset for both? Bastien

From: Micah Stevens <micah@raincross-tech.com> To: php-db@lists.php.net Subject: Re: [PHP-DB] Case sensitive Date: Wed, 24 Aug 2005 11:26:38 -0700 Not sure here, as according to my experience, and the MySQL docs, SQL pattern matching (as you would use with the 'LIKE' syntax) is case-insensitive. From the docs: "In MySQL, SQL patterns are case-insensitive by default. Some examples are shown here. " http://dev.mysql.com/doc/mysql/en/pattern-matching.html If this for some reason is different on your server, another route (although likely slower) is a REGEXP search.. -Micah On Wednesday 24 August 2005 1:53 pm, Chris Payne wrote: Hi there everyone, I have a little problem, I have a search where people can search the address of a property BUT the search is case sensitive, I don’t WANT it to be. I’m using MySQL and PHP and I generally use something like WHERE address LIKE ‘%$stringinput%’ which works with the numbers ONLY, but when I add the address if I don’t put a capital infront of each part of the address it won’t show up. Any ideas how I can make it case INSENSITIVE? (Think that’s the correct phrase). Any help would really be appreciated. Thanks everyone Regards Chris Payne -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php