[RFH] Full Text search

[Imran M Yousuf]

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