Mercurial > epgrec.yaz
diff Keyword.class.php @ 118:db185340a981
utf8 collate try1
author | Yoshiki Yazawa <yaz@honeyplanet.jp> |
---|---|
date | Sun, 14 Mar 2010 20:16:04 +0900 |
parents | 7a64d5e3baee |
children | a18df712fc7e |
line wrap: on
line diff
--- 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 +?>