- 搜索英文问题
问题描述:
被搜索名字为:andy
这时搜索andy正常,但是搜索a就搜不到。
解决办法,在索引配置文件中的index中添加
min_infix_len = 1
最后还要重新索引一下/usr/local/coreseek/bin/indexer -c mysql.conf mysql --rotate
上面的命令不要直接复制确定好自己coreseek的安装目录找到bin下面的命令才行
- 匹配到的结果是只有搜索到的总数的一部分
- 中文搜索无结果集
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
7 rows in set (0.00 sec)
复制/usr/share/doc/mysql-server-5.1.69/my-large.cnf文件到/etc/my.cnf
cp /usr/share/doc/mysql-server-4.1.12/my-large.cnf /etc/my.cnf
3、打开my.cnf修改编码
vi /etc/my.cnf
在[mysqld]下添加
default-character-set=utf8
在[client]下添加
default-character-set=utf8
4、重启MySQL服务
service mysqld restert
5、登录mysql看看修改成功否
show variables like 'character%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
如果显示以上信息表示修改成功了
mysql> alter database name character set utf8;
修改表默认用utf8.
mysql> alter table type character set utf8;
修改字段用utf8
mysql> alter table type modify type_name varchar(50) CHARACTER SET utf8;