SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I tried to use FullTextSqlQuery for people search. This is my code:

FullTextSqlQuery q = new FullTextSqlQuery(SPContext.Current.Site);
q.ResultTypes = ResultType.RelevantResults;
q.QueryText = "SELECT PreferredName, AccountName, JobTitle FROM SCOPE() WHERE \"scope\" = 'People' AND CONTAINS(JobTitle, 'test')";
ResultTableCollection tables = q.Execute();
ResultTable results = tables[ResultType.RelevantResults];

It works fine, but if I use search word in Russian language, the result table is empty.

"SELECT PreferredName, AccountName, JobTitle FROM SCOPE() WHERE \"scope\" = 'People' AND CONTAINS(JobTitle, 'тест')"

I found that CONTAINS function has LCID parameter and I tried use it, but I did not have any luck.

"SELECT PreferredName, AccountName, JobTitle FROM SCOPE() WHERE \"scope\" = 'People' AND CONTAINS(JobTitle, 'тест', 1049)"

What did I do wrong?

share|improve this question
Have you tried to setup Culture property? – Kai Apr 11 '12 at 10:31
yes, I tried... – Alexander Apr 11 '12 at 11:18
@Kai, I think that I miss something in search service settings. But I do not have any idea what can it be ((( – Alexander Apr 11 '12 at 12:01
I am not sure this is your problem but you can try to configure this please check… – Vishal_Sharepoint Apr 12 '12 at 5:31
If you are using SP2010, did you try with keyword query? FTSQL is kind of depricated and often hard to work with. Keyword query is the way to go :-) – Anders Rask Jun 1 '12 at 13:12
up vote 1 down vote accepted

I found this explanation:

SQL Server 2000 and SQL Server 2005 full-text search supports only one language for each database. If you are supporting Windows SharePoint Services Web sites in several languages and you want to enable full-text search in those languages, consider hosting each language on a separate virtual server with a separate database per language.

Fool text of the post can be found by this link.

share|improve this answer
you can feel free to mark this as the answer. It answers the question for me! – Tom Resing Oct 23 '12 at 0:37

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.