I have been struggling with the following query:
select * from table_name where contains((field1,field2), "S.E.N.S" );
Following is the text I have in field 1: "S.E.N.S Productions"
如果我找“ 生产” 我取得了结果,但不是“S.E.N.S。
关于如何取得预期结果的想法? 感谢。
更新:Sql服务器版本2005年,SP3。
Update: Well, it is quite weird. When I set the full-text to use noiseENG.txt the query in my question works fine. But everything stored in the database is in Turkish and all the settings are set accordingly, including noiseTRK.txt. "S.E.N.S" is not a word in Turkish nor in English as far as I know. I can set it to noiseENG.txt to get it work, but I doubt that would be appropriate. Can anyone know/think of a reason why noiseTRK.txt would break in above query ? Thanks.
P.S.我用未经修改的噪音文档以及单字母的土耳其噪音文档进行了测试。