Mercurial > epgrec.yaz
comparison 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 |
comparison
equal
deleted
inserted
replaced
117:f5d58cf2842f | 118:db185340a981 |
---|---|
34 if( $keyword != "" ) { | 34 if( $keyword != "" ) { |
35 if( $use_regexp ) { | 35 if( $use_regexp ) { |
36 $options .= " AND CONCAT(title,description) REGEXP '".mysql_real_escape_string($keyword)."'"; | 36 $options .= " AND CONCAT(title,description) REGEXP '".mysql_real_escape_string($keyword)."'"; |
37 } | 37 } |
38 else { | 38 else { |
39 $options .= " AND CONCAT(title,description) like '%".mysql_real_escape_string($keyword)."%'"; | 39 $options .= " AND CONCAT(title,description) like _utf8'%".mysql_real_escape_string($keyword)."%' collate utf8_unicode_ci"; |
40 } | 40 } |
41 } | 41 } |
42 | 42 |
43 if( $type != "*" ) { | 43 if( $type != "*" ) { |
44 $options .= " AND type = '".$type."'"; | 44 $options .= " AND type = '".$type."'"; |