Search Lower versus Uppercase

Submitted by john100 on Thu, 2011-05-05 16:41 in Price Tapestry

Hi David,

First of all, I would like to thank you for your product. I bought it yesterday and I am impressed.

I have read a few post regarding search.php to solve an upper versus lower case results issue.
But I did not find any answer.

As I had the same type of issue for an another website, I jumped into the code to solve it (but you might have a nicer way to do it).

The issue:
"Le baiser" versus "le baiser"

To solve that I "strtolowered" the $q variable and did the same for every mysql query using LCASE.
It seems to solve the issue for every case I came accross so far.

Now, I can spell products names as I write.
Le baiser can be written LE BAISER, Le BaIsEr, le baiser, LE baiser, le BAISER...

Hi John, Thanks for that!

Submitted by support on Thu, 2011-05-05 16:50

Hi John,

Thanks for that! Ordinarily MySQL should be case insensitive but I am familiar with working with users running non-English language sites in which a modification to handle accented vowels (by converting to the non-accented equivalents) has helped - if you would be interested in that let me know!

Cheers,
David.
--
PriceTapestry.com

I am. Thanks

Submitted by john100 on Thu, 2011-05-05 19:24

I am.
Thanks

Hi John, I'll follow up by

Submitted by support on Thu, 2011-05-05 19:29

Hi John,

I'll follow up by email with the accented vowels mod.

Cheers,
David.
--
PriceTapestry.com

Hi David, I have the same

Submitted by Tkconcept on Wed, 2012-08-29 08:09

Hi David,

I have the same issue.
Can you help me to solve this issue please ?

Thanks.

Hi, No problem - I see

Submitted by support on Wed, 2012-08-29 10:12

Hi,

No problem - I see you've been using the script for a long time so i'll make the changes on your latest files, if you could email me your search.php and includes/tapestry.php i'll make the changes for you...

Cheers,
David.
--
PriceTapestry.com