S
S
sajgak2011-02-16 01:44:19
MySQL
sajgak, 2011-02-16 01:44:19

mysql adding "-" to character list

There was a need for full-text search to search for words with a dash (by default, the "-" character is a logical operator and is not considered a character).
The manual says:

Modify a character set file: This requires no recompilation. The true_word_char() macro uses a “character type” table to distinguish letters and numbers from other characters.. You can edit the contents in one of the character set XML files to specify that '-' is a “letter.” Then use the given character set for your FULLTEXT indexes.

But Google doesn’t know where this character set file is located :( Has anyone encountered a similar one?

Thank you

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
apangin, 2011-02-16
@apangin

<mysql_dir>/share/charsets/*.xml?
It seems to be about the fact that in the ctype / map table from this file you need to register the same type for the '-' character as for the letter.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question