The following fixes in the nuform.php file solved for me this problem.
In the function nuBrowseWhereClause:
Code: Select all
if ($task[$i] == 'include') {
$include[] = $searchFields[$SF] . ' LIKE ' . $SEARCHES[$i];
} else {
$exclude[] = $searchFields[$SF] . ' NOT LIKE ' . $SEARCHES[$i];
}
Code: Select all
if ($task[$i] == 'include') {
$include[] = 'CONVERT(' . $searchFields[$SF] . ' USING utf8) LIKE ' . $SEARCHES[$i];
} else {
$exclude[] = 'CONVERT(' . $searchFields[$SF] . ' USING utf8) NOT LIKE ' . $SEARCHES[$i];
}