Print

[rebro]

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

[rebro]

Morning *,

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

greets
rebro

[Nibbler]

http://dev.mysql.com/doc/refman/5.1/en/case-sensitivity.html

[rebro]

Hi Nibbler,

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

Code: [Select]

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

[Αndré]

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.

[rebro]

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

[ThunderBoy]

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.

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