Re: Case sensitive

Check to see if you have the Binary option on the field. That would make searches case sensitive. If it is a binary field, you need to drop the binary option. On Aug 24, 2005, at 4: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 --No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.10.15/80 - Release Date: 8/23/2005

-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577