Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: case-sensitive search  (Read 3319 times)

0 Members and 1 Guest are viewing this topic.

rebro

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 11
case-sensitive search
« 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
Logged
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

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 11
Re: case-sensitive search
« Reply #1 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
Logged
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.

Nibbler

  • Guest
Logged

rebro

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 11
Re: case-sensitive search
« Reply #3 on: August 31, 2010, 01:03:49 pm »

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

Logged
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é

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: case-sensitive search
« Reply #4 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.
Logged

rebro

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 11
Re: case-sensitive search
« Reply #5 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
Logged
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

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 5
    • Photograph
Re: case-sensitive search
« Reply #6 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.

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)
Logged
I apologize for my english :)
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 19 queries.