Sql Server 2008全文索引（字符问题）

问题描述

全文索引搜索工作正常，但突然间我注意到它在阿拉伯文中的某些字符变化时失败了

在阿拉伯文我们有一个尾随字母说{I}，可以像{i}或{I}那样写，它是相同的字母，但是不同的ASCII码，就像{i}& {I}

Contains函数可以获得ALi而不是ALI

$ ul $ b

{ALi& ALI}存在。

{ALi}返回结果，但没有{ALI}的结果。文本搜索..

任何想法??

谢谢

解决方案

您是否对阿拉伯语实施了不同的索引？
您需要为每个不同的排序规则添加一个索引

The Full-Text Index searching is working perfect but suddenly I noticed that it fails when it comes to some characters variance in Arabic

In Arabic we have a trailing letter say {I} that can be written like { i } or { I } , It's the same letter but different ASCII code.. exactly like the English variance between { i } & { I }

the "Contains" function can get "ALi" but not "ALI"

• both {ALi & ALI} exist..
• {ALi} returns result but without the result of {ALI}
• {ALI} return 0 records when using full-text searching..

Any ideas??

Thanks

解决方案

did you implement a different index to arabic?You need one index to each different collation

这篇关于Sql Server 2008全文索引（字符问题）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！