Bug #29818 search in full text
Submitted: 16 Jul 2007 12:29 Modified: 16 Jul 2007 13:01
Reporter: Vladislav Stoitsov Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: FULLTEXT search Severity:S3 (Non-critical)
Version:5.0.41-log OS:Any
Assigned to: CPU Architecture:Any

[16 Jul 2007 12:29] Vladislav Stoitsov 
Description:
When i try to search using FULL TEXT Search in a table whit cyrillic chars mysql returns 0 results

How to repeat:
CREATE TABLE `_pages_lang` (
  `id` int(10) NOT NULL auto_increment,
  `pageid` int(10) NOT NULL,
  `langid` int(10) NOT NULL,
  `title` varchar(255) NOT NULL,
  `pageTitle` varchar(255) NOT NULL,
  `keywords` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `html` longtext NOT NULL,
  `lefthtml` longtext NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`,`pageid`,`langid`),
  FULLTEXT KEY `title` (`title`),
  FULLTEXT KEY `html` (`html`),
  FULLTEXT KEY `description` (`description`),
  FULLTEXT KEY `keywords` (`keywords`),
  FULLTEXT KEY `pageTitle` (`pageTitle`),
  FULLTEXT KEY `full_index` (`title`,`pageTitle`,`keywords`,`description`,`html`)
) ENGINE=MyISAM AUTO_INCREMENT=118 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

SELECT id, title,
	MATCH(title,pageTitle,keywords,description,html) 
	AGAINST ('информация') AS score FROM _pages_lang 
WHERE
	MATCH(title,pageTitle,keywords,description,html) 
	AGAINST ('информация') ORDER BY score DESC
[16 Jul 2007 13:01] Sveta Smirnova 
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Your table created with options "CHARSET=latin1 COLLATE=latin1_general_ci" which don't contain Cyrillic characters.

Please read about character set support in MySQL at http://dev.mysql.com/doc/refman/5.0/en/charset.html and http://dev.mysql.com/doc/refman/5.0/en/charset-cyrillic-sets.html