coppermine-gallery.com/forum

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: rebro on August 30, 2010, 09:58:55 AM

Title: case-sensitive search
Post by: rebro on August 30, 2010, 09:58:55 AM
good morning *,

i'm looking for a plugin or an entry in the search.php which makes the search case sensitive.
I defined several keywords for the coppermine search.

Everytime I'm looking for "Uli" I got pictures with "Uli" and "Julia" as keyword.
So I need something which makes my search case sensitive or something else.

greets
rebro
Title: Re: case-sensitive search
Post by: rebro on August 31, 2010, 11:26:31 AM
Morning *,

no idea?
I tried to find the search function in the search.php but my php-knowledge is very bad.

greets
rebro
Title: Re: case-sensitive search
Post by: Nibbler on August 31, 2010, 11:52:14 AM
http://dev.mysql.com/doc/refman/5.1/en/case-sensitivity.html
Title: Re: case-sensitive search
Post by: rebro on August 31, 2010, 01:03:49 PM
Hi Nibbler,

well I checked my database but there is no failure.
MySQL is case sensitive ...

mysql> SET @s1 = 'MySQL' COLLATE latin1_bin,
    -> @s2 = 'mysql' COLLATE latin1_bin;
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT @s1 = @s2;
+-----------+
| @s1 = @s2 |
+-----------+
|         0 |
+-----------+
1 row in set (0.00 sec)


Any other ideas?

greets
rebro

Title: Re: case-sensitive search
Post by: ΑndrĂ© on September 02, 2010, 12:35:45 PM
We had a few support request regarding the keyword search. Users wanted to find only full keywords instead of parts (like your uli/julia example). Please search the board to find these threads if that's what you want.
Title: Re: case-sensitive search
Post by: rebro on September 02, 2010, 03:31:18 PM
Hello André,

thanks for your help.
This post helps me:
http://forum.coppermine-gallery.net/index.php/topic,34234.0/prev_next,prev.html#new

greets
rebro
Title: Re: case-sensitive search
Post by: ThunderBoy on October 15, 2010, 09:56:35 AM
And how do i disable search with resolution uppercase and lowercase letters?
When i enter a search phrase: koniec sveta, so i can not find anything when i enter: Koniec sveta, so i find the result. You can try directly in my gallery http://www.thunderboy.eu/fotogaleria/search.php (http://www.thunderboy.eu/fotogaleria/search.php).

I want to make me not take into account the size of characters or the right to choose that option when searching.
How do i change?
Thank you 8)