mysql的全文搜索支持中文吗?
mysql的全文搜索支持中文吗?
我在4.0.22版、4.1.7版及5.0.5alpha版都测试过了,都不支持中文,不知道是不是我哪里出错了?
请大家指点,谢谢?
我的测试代码如下:
CREATE TABLE `articles` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(200) default NULL,
`body` text,
PRIMARY KEY (`id`),
FULLTEXT KEY `title` (`title`,`body`)
) TYPE=MyISAM AUTO_INCREMENT=1;
INSERT INTO `articles` VALUES (1, 'MySQL Tutorial', 'DBMS stands for DataBase ...');
INSERT INTO `articles` VALUES (2, 'How To Use MySQL Efficiently', 'After you went through a ...');
INSERT INTO `articles` VALUES (3, 'Optimising MySQL', 'In this tutorial we will show ...');
INSERT INTO `articles` VALUES (4, '1001 MySQL Tricks', '1. Never run mysqld as root. 2. ...');
INSERT INTO `articles` VALUES (5, 'MySQL vs. YourSQL', 'In the following Database comparison ...');
INSERT INTO `articles` VALUES (6, 'MySQL Security DataBase', 'When configured properly, MySQL ...');
INSERT INTO `articles` VALUES (7, '中文信息', '这里含有 中文 信息');
运行下面查询语句后,可以得到正确的结果:
SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database');
但如果下面这句搜索中文的查询语句后,却搜索不到任何内容。
SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('中文');
请问是我的问题还是mysql的全文搜索本身不支持中文?