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

News:

CPG Release 1.6.28
added submissions from {406man}
cleaned up a few PHP (8.4) deprecations
fixed PHP deprecation in calendar
removed security vulnerability
(please upgrade when possible)

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.