MySql全文搜索是否可以合理使用非拉丁语言（希伯来语，阿拉伯语，日语...） [英] Does MySql full text search works reasonably with non-Latin languages (Hebrew, Arabic, Japanese...)

问题描述

MySql全文搜索是否可以合理地与非拉丁语言结合使用？ （希伯来语，阿拉伯语，日语...）

补充：做了一些测试......它有一些希伯来语的问题。例如：מוסינזון的名字与מושינזון的发音相同，但搜索一个不会找到另一方面，因为这是希伯来语中常见的拼写错误，所以我似乎必须对其进行一些数据处理才能完美工作。

解决方案

虽然希伯来语在MySQL中的支持有限，但您的问题更多的是使用不正确拼写的问题， MySQL服务器在这个角度看。当您在Google拼写错误时，会显示一条建议，您可以点击该建议来搜索该字词。

也许你可以创建一些具有相同行为的程序，例如您可以创建一个包含两个字段的表格，其中一个包含拼写错误的单词，另一个包含正确的拼写。然后，您可以构建一个程序来查找拼写错误的单词并显示建议。

Does MySql full text search works reasonably with non-Latin languages? (Hebrew, Arabic, Japanese...)

Addition: Did some tests... It has some problems with Hebrew. Example: The name מוסינזון is pronounced the same as מושינזון but searching one won't find the other, as this is a common spelling error in Hebrew, it seems I will have to do some data manipulation for it to work perfectly.

解决方案

Though Hebrew support in MySQL is limited, your problem is more a problem of people using incorrect spelling, then a dysfunction of the MySQL server in this perspective. When you misspell a word in Google, it will show you a suggestion and you can click on that suggestion to search for that term.

Perhaps you could build some program that has the same behaviour, e.g. you could create a table that has 2 fields, one containing the commonly misspelled word and the other containing the correct spelling. You could then build a program that finds the misspelled word and displays the suggestion.

这篇关于MySql全文搜索是否可以合理使用非拉丁语言（希伯来语，阿拉伯语，日语...）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！