Searching for cyrillic words

kostandin · August 29th, 2005, 06:07 AM

Hello everyone!

I have a problem searching through a SQL Server 2000 database with cyrillic search term using 'contains' predicate. I have enabled full-text searching on database, table and column I'm searching in, populated my catalog, but when I try to search I'm getting this error:
Server: Msg 7619
Execution of a full-text operation failed. A clause of the query contained only ignored words.

This is search script:

Code:

SELECT * FROM OrgEntity as oe WHERE contains(oe.Name, '{the word im searching for}')

When I use LIKE, it works fine, but I think LIKE is slower and not applicable on tables with many rows.

Can anyone help me, please?

Kostandin

kostandin · September 1st, 2005, 05:44 PM

:(:(:(:(
This is not the problem with only cyrillic, but with any non standard characters. There must be someone who did full-text search in japanese, chinese, russian, arabic or any other language different from english!

In hope that someone knows the answer or at least a place where I can search,

Kostandin