Do not look for keywords in small letters Do not look for keywords in small letters
 

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

Do not look for keywords in small letters

Started by serg5777, August 05, 2013, 10:56:24 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

serg5777

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 :)

serg5777


ΑndrĂ©

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.