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
+?>