Advanced 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

Pages: [1]   Go Down

Author Topic: Do not look for keywords in small letters  (Read 2058 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.021 seconds with 20 queries.