case-sensitive search case-sensitive search
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

case-sensitive search

Started by rebro, August 30, 2010, 09:58:55 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

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
My coppermine gallery is offline and I'm atm not allowed to bring it online.

Two hours of trial and error can save ten minutes of manual reading.

rebro

Morning *,

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

greets
rebro
My coppermine gallery is offline and I'm atm not allowed to bring it online.

Two hours of trial and error can save ten minutes of manual reading.


rebro

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

My coppermine gallery is offline and I'm atm not allowed to bring it online.

Two hours of trial and error can save ten minutes of manual reading.

Α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

My coppermine gallery is offline and I'm atm not allowed to bring it online.

Two hours of trial and error can save ten minutes of manual reading.

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 8)
I apologize for my english :)