Havin troubles with freetext (didn't get an answer searchin overhere)

Question

Hi i have a simple question...

What i need to fix to use freetext when i using cyrrilic lang database ?!
(but all my tables contains only english words)

1. I made fts catalog with english language
2. I made fts index in my table ...
3. I wrote the query which contains : select * from dbo.table where freetext (*, 'X')
4. runned the query an i didnt get any rows but all my rows contains the word Xilinx in the second column...

Im using russian localised sql server ...

think i got a problem with some local settings but every time i change something in my database and table (i even add table with russian words only with freetext index ) it still doesnt work

thank you for your help with it !

Answer 1

I would try this:

select * From dbo.table where freetext((, 'My Search Phrase' LANGUAGE 1033)

---

looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941