diff options
author | Michal Čihař <mcihar@novell.com> | 2011-06-14 11:15:07 +0400 |
---|---|---|
committer | Michal Čihař <mcihar@novell.com> | 2011-06-14 11:15:07 +0400 |
commit | 8cebaca19b08f8faa5eaebfdb2d87c466f274db8 (patch) | |
tree | 8dc0dfb6a40f0d1297498709b78b326f6a9b1e16 /db_search.php | |
parent | c4c8fcb2b5fbf88fbe6dbcc987fd104d060eac4d (diff) |
bug #3315720 [search] Fix search in non unicode tables
We need to convert field to unicode because the connection is in utf-8
and we might give utf-8 input as well.
Diffstat (limited to 'db_search.php')
-rw-r--r-- | db_search.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/db_search.php b/db_search.php index fba68d17fe..d93fd74d87 100644 --- a/db_search.php +++ b/db_search.php @@ -178,7 +178,7 @@ if (isset($_REQUEST['submit_search'])) { $thefieldlikevalue = array(); foreach ($tblfields as $tblfield) { if (! isset($field) || strlen($field) == 0 || $tblfield == $field) { - $thefieldlikevalue[] = PMA_backquote($tblfield) + $thefieldlikevalue[] = 'CONVERT(' . PMA_backquote($tblfield) . ' USING utf8)' . ' ' . $like_or_regex . ' ' . "'" . $automatic_wildcard . $search_word |