You are here:  » Search operation case insensitive.

Support Forum



Search operation case insensitive.

Submitted by Frank Hollander on Wed, 2007-05-30 13:55 in

Hi David,

Is it possible to make the search operation case insensitive. Because a lot of important keywords started with a capital or some words are whole written in capital, most people do not search with capital letters. When I search for the word TV and tv both should match all the words in the database like Tv, tv ,tV and return them in the search results of TP.

I hope there is a solution for this.

Thanks in advance,
Frank

Submitted by support on Thu, 2007-05-31 12:54

Hi Frank,

The search should be case insensitive as this is MySQL's default configuration for WHERE comparison against the VARCHAR data type. It is possible that your server is configured differently. Can you email me a link to your site so that I can take a look... Reply to your reg code or forum registration email is the easiest way to get me...

Cheers,
David.