Description:
Arabic Problem With full text search and some characters in boolean mode i want to ignor some charcter before indexing the table like this ex in English
for the word (Don't) it index with (dont) so the fulltext ignor the (') i want to change this list of characters and add another new characters
ALSO THIS IS an example in english word but i think that it's the same that we have to ignore the („) & (“) TO GET ALL THE RECORD
CREATE TABLE `fulltext_utf8` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`text` VARCHAR( 255 ) NOT NULL ,
FULLTEXT (`text`)
) ENGINE = MYISAM DEFAULT CHARSET=utf8;
INSERT INTO `fulltext_utf8` VALUES (NULL , '„MySQL“'), (NULL , 'MySQL');
SELECT `id`, `text` FROM `fulltext_utf8` WHERE MATCH (`text`) AGAINST ('MySQL'
IN BOOLEAN MODE);
I hope you answer me asap
How to repeat:
Execute the following SQL queries:
CREATE TABLE `fulltext_utf8` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`text` VARCHAR( 255 ) NOT NULL ,
FULLTEXT (`text`)
) ENGINE = MYISAM DEFAULT CHARSET=utf8;
INSERT INTO `fulltext_utf8` VALUES (NULL , '„MySQL“'), (NULL , 'MySQL');
SELECT `id`, `text` FROM `fulltext_utf8` WHERE MATCH (`text`) AGAINST ('MySQL'
IN BOOLEAN MODE);
+----+-------+
| id | text |
+----+-------+
| 2 | MySQL |
+----+-------+
1 row in set (0.00 sec)
As you can see the SELECT statement only matches the second row, although it
should match both rows.
Suggested fix:
EDIT THE LIST which have the ' character for ignoring and add the new chracters which we want to ignore in indexing
IGNORE SOME CHRACTERS LIKE ',",„,,, ّ َ ُ ٌ ِ ٍ ْ
Description: Arabic Problem With full text search and some characters in boolean mode i want to ignor some charcter before indexing the table like this ex in English for the word (Don't) it index with (dont) so the fulltext ignor the (') i want to change this list of characters and add another new characters ALSO THIS IS an example in english word but i think that it's the same that we have to ignore the („) & (“) TO GET ALL THE RECORD CREATE TABLE `fulltext_utf8` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , `text` VARCHAR( 255 ) NOT NULL , FULLTEXT (`text`) ) ENGINE = MYISAM DEFAULT CHARSET=utf8; INSERT INTO `fulltext_utf8` VALUES (NULL , '„MySQL“'), (NULL , 'MySQL'); SELECT `id`, `text` FROM `fulltext_utf8` WHERE MATCH (`text`) AGAINST ('MySQL' IN BOOLEAN MODE); I hope you answer me asap How to repeat: Execute the following SQL queries: CREATE TABLE `fulltext_utf8` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , `text` VARCHAR( 255 ) NOT NULL , FULLTEXT (`text`) ) ENGINE = MYISAM DEFAULT CHARSET=utf8; INSERT INTO `fulltext_utf8` VALUES (NULL , '„MySQL“'), (NULL , 'MySQL'); SELECT `id`, `text` FROM `fulltext_utf8` WHERE MATCH (`text`) AGAINST ('MySQL' IN BOOLEAN MODE); +----+-------+ | id | text | +----+-------+ | 2 | MySQL | +----+-------+ 1 row in set (0.00 sec) As you can see the SELECT statement only matches the second row, although it should match both rows. Suggested fix: EDIT THE LIST which have the ' character for ignoring and add the new chracters which we want to ignore in indexing IGNORE SOME CHRACTERS LIKE ',",„,,, ّ َ ُ ٌ ِ ٍ ْ