使用全文搜索波斯语 [英] Use Full Text Search for Persian Language
问题描述
我看到了 支持的语言 进行全文本搜索(SQL Server 2012). 波斯语(波斯语)在列表中不存在.但是据我所知，有一种方法可以通过添加自定义词典，使用阿拉伯语等对波斯语进行全文搜索.
I see supported language in full text search (SQL Server 2012). Persian (Farsi) does not exist in list. But as I know, there is a way to use full text search for Persian language with adding custom dictionary, using Arabic language and etc.
请帮助并给我一些有关在SQL Server 2012的全文本搜索中使用波斯语的参考和指导.
Please help and give me some references and guidance for using Persian language in Full Text Search of SQL Server 2012.
推荐答案
是的，FTS不支持波斯语，但这并不意味着它不能与波斯语一起使用.波斯语语言仅不支持诸如WHERE CONTAINS(docexcerpt, N'FORMSOF(INFLECTIONAL, presentation)');之类的inflectional查询.因为这些类型的查询需要有关指定语言的结构和语法的大量信息.否则，您可以使用SELECT id, title, docexcerpt FROM dbo.Documents WHERE CONTAINS(docexcerpt, N'سلام');
Yes FTS doesn't support Persian language, but that doesn't mean it won't work with it. Only inflectional queries such as WHERE CONTAINS(docexcerpt, N'FORMSOF(INFLECTIONAL, presentation)'); are not supported for Persian language. Because these types of queries need a lot of information about the structure and grammar of the specified language. Otherwise you can use queries like SELECT id, title, docexcerpt FROM dbo.Documents WHERE CONTAINS(docexcerpt, N'سلام');
这篇关于使用全文搜索波斯语的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
