From: Imran M Yousuf (imyousufgmail.com)
Date: Tue Feb 26 2008 - 23:46:29 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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 TIME_ZONE=OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=OLD_SQL_NOTES */;

-- Dump completed on 2008-02-27 5:41:23

Thank you,

--
Imran M Yousuf
Entrepreneur & Software Engineer
Smart IT Engineering
Dhaka, Bangladesh
Email: imransmartitengineering.com
Mobile: +880-1711402557

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]