Dear Users, I am facing a problem related to full text search. I am trying to search non latin characters with no success :(.
I am trying the following queries for searching and only the English one works. SELECT * FROM bangla_test WHERE MATCH(bn_test) AGAINST('নাম নাই' in boolean mode) SELECT * FROM bangla_test WHERE MATCH(bn_test) AGAINST('test' in boolean mode) SELECT * FROM bangla_test WHERE MATCH(bn_test) AGAINST('日系人' in boolean mode) The dump of the database is following this paragraph. I would be grateful if someone could be point me what I am doing wrong. -- MySQL dump 10.11 -- -- Host: localhost Database: test -- ------------------------------------------------------ -- Server version 5.0.38-Ubuntu_0ubuntu1.2-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Current Database: `honeybase` -- /*!40000 DROP DATABASE IF EXISTS `test`*/; CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `honeybase`; -- -- Table structure for table `bangla_test` -- DROP TABLE IF EXISTS `bangla_test`; CREATE TABLE `bangla_test` ( `id` int(11) NOT NULL auto_increment, `bn_test` varchar(255) NOT NULL, PRIMARY KEY (`id`), FULLTEXT KEY `bn_full_text` (`bn_test`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; -- -- Dumping data for table `bangla_test` -- LOCK TABLES `bangla_test` WRITE; /*!40000 ALTER TABLE `bangla_test` DISABLE KEYS */; set autocommit=0; INSERT INTO `bangla_test` VALUES (1,'নাম নাই'),(2,'test'),(3,'日系人'),(4,'another test'),(5,'dingdong'); /*!40000 ALTER TABLE `bangla_test` ENABLE KEYS */; UNLOCK TABLES; commit; /*!40103 SET [EMAIL PROTECTED] */; /*!40101 SET [EMAIL PROTECTED] */; /*!40014 SET [EMAIL PROTECTED] */; /*!40014 SET [EMAIL PROTECTED] */; /*!40101 SET [EMAIL PROTECTED] */; /*!40101 SET [EMAIL PROTECTED] */; /*!40101 SET [EMAIL PROTECTED] */; /*!40111 SET [EMAIL PROTECTED] */; -- Dump completed on 2008-02-27 5:41:23 Thank you, -- Imran M Yousuf Entrepreneur & Software Engineer Smart IT Engineering Dhaka, Bangladesh Email: [EMAIL PROTECTED] Mobile: +880-1711402557