All geek questions in one place

How to use full-text search in SQL Server 2012 for Persian

I see a supported language in full-text search (Sql server 2012). Persian (Farsi) does not exist on the list. But, as I know, there is a way to use the full-text search of the Persian language with the addition of a user dictionary, using the Arabic language, etc.

Please help and give me some tips and tricks for using Persian in FTS SQL Server 2012.

+6
source share
1 answer

Yes, the FTS does not support the Persian language, but this does not mean that it will not work with it. Only inflectional queries, such as WHERE CONTAINS(docexcerpt, N'FORMSOF(INFLECTIONAL, presentation)'); are not supported for the Persian language. Since these types of queries require a lot of information about the structure and grammar of the specified language. Otherwise, you can use queries such as SELECT id, title, docexcerpt FROM dbo.Documents WHERE CONTAINS(docexcerpt, N'سلام');

Additional information in Persian

+4
source

Source: https://habr.com/ru/post/983659/

More articles:


All Articles