Welcome to the nuBuilder Forums!

Register and log in to access exclusive forums and content available only to registered users.

Date column gives search error in Browse Form

Questions related to using nuBuilder Forte.
Post Reply
KEE
Posts: 14
Joined: Sat Feb 24, 2018 1:17 pm
Been thanked: 2 times

Date column gives search error in Browse Form

Unread post by KEE »

Date column gives error for Illegal mix of collations for operation 'like', when typing "non-latin" characters.
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];
            }
I have fix:

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];
            }

admin
Site Admin
Posts: 2814
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 25 times

Re: Date column gives search error in Browse Form

Unread post by admin »

KEE,

Thanks for that, I've put your changes on Github.

Steven
Post Reply