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: Do not look for keywords in small letters  (Read 2052 times)

0 Members and 1 Guest are viewing this topic.

serg5777

  • Coppermine frequent poster
  • ***
  • Country: ru
  • Offline Offline
  • Gender: Male
  • Posts: 171
    • Широкоформатные обои для рабочего стола
Do not look for keywords in small letters
« on: August 05, 2013, 10:56:24 am »

This form of search on the site:
<div class="searchbox">
<form method="get" action="thumbnails.php" name="searchcpg" id="cpgform3">
<input type="text" style="width: 70%" name="search" maxlength="255" value="" class="textinput" />
<input type="hidden" name="album" value="search"/>
<input type="hidden" name="title" value="on"/>
<input type="hidden" name="keywords" value="on"/>            
<input type="hidden" name="caption" value="on"/>   
<input type="submit" value="Search" class="button"/>
</form>
</div>
Finds keywords only if administered in the search word with a capital letter:
"Нина" - finds
"нина" - not finds
Help me please :)
Logged

serg5777

  • Coppermine frequent poster
  • ***
  • Country: ru
  • Offline Offline
  • Gender: Male
  • Posts: 171
    • Широкоформатные обои для рабочего стола
Re: Do not look for keywords in small letters
« Reply #1 on: August 05, 2013, 10:59:26 am »

Language - Russian
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Do not look for keywords in small letters
« Reply #2 on: August 23, 2013, 02:32:16 pm »

As far as I know the commonly used default MySQL collations are not case sensitive. Maybe you use a case sensitive collation, but it's maybe a Unicode issue. There are already some threads in our board dealing with that issue. Some people WANT to have a case sensitive search and therefore changed the table collations. Maybe you can do the opposite. There's also an open thread in the bug board.

Unfortunately I cannot give you a direction what exactly you have to do, as I also have to look closer at that issue.
Logged
Pages: [1]   Go Up
 

Page created in 0.029 seconds with 19 queries.