From 9083d4227f9b7cd5f5622d9eb3a1e7243e653868 Mon Sep 17 00:00:00 2001
From: bradymiller <bradymiller@users.sourceforge.net>
Date: Wed, 18 Jul 2012 10:48:40 -0700
Subject: [PATCH] Collation bug fix when making entering in new patient names
 that contain UTF8 characters, such as chinese characters.

---
 interface/new/new_search_popup.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/interface/new/new_search_popup.php b/interface/new/new_search_popup.php
index d25d6a14a..9c30225d8 100644
--- a/interface/new/new_search_popup.php
+++ b/interface/new/new_search_popup.php
@@ -147,7 +147,6 @@ foreach ($_REQUEST as $key => $value) {
     array_push($sqlBindArray, $value);
   }
   $where .= " OR ".add_escape_custom($fldname)." LIKE ?";
-  array_push($sqlBindArray, $value);
   array_push($sqlBindArraySpecial, $value);
   echo "<input type='hidden' name='".htmlspecialchars( $key, ENT_QUOTES)."' value='".htmlspecialchars( $value, ENT_QUOTES)."' />\n";
   ++$numfields;
@@ -159,6 +158,7 @@ $sql = "SELECT *, ( $relevance ) AS relevance, " .
   "ORDER BY relevance DESC, lname, fname, mname " .
   "LIMIT ".add_escape_custom($fstart).", ".add_escape_custom($MAXSHOW)."";
 
+$sqlBindArray = array_merge($sqlBindArray, $sqlBindArraySpecial);
 $rez = sqlStatement($sql, $sqlBindArray);
 $result = array();
 while ($row = sqlFetchArray($rez)) $result[] = $row;
-- 
2.11.4.GIT