# HG changeset patch # User Yoshiki Yazawa # Date 1268565364 -32400 # Node ID db185340a981daf137b428dc9d822ec0b9054700 # Parent f5d58cf2842ffee783e7a70d5b83fc9331d712fc utf8 collate try1 diff -r f5d58cf2842f -r db185340a981 Keyword.class.php --- a/Keyword.class.php Sun Mar 14 16:31:50 2010 +0900 +++ b/Keyword.class.php Sun Mar 14 20:16:04 2010 +0900 @@ -36,7 +36,7 @@ $options .= " AND CONCAT(title,description) REGEXP '".mysql_real_escape_string($keyword)."'"; } else { - $options .= " AND CONCAT(title,description) like '%".mysql_real_escape_string($keyword)."%'"; + $options .= " AND CONCAT(title,description) like _utf8'%".mysql_real_escape_string($keyword)."%' collate utf8_unicode_ci"; } } @@ -163,4 +163,4 @@ parent::__destruct(); } } -?> \ No newline at end of file +?>