全文索引 CONTAINS 模糊查询

[初学者--]

我创建了数据库COMPANY，并在字段FMARK上建立了全文索引，然后查询：
SELECT * FROM COMPANY WHERE CONTAINS(FMARK,'FORMSOF(THESAURUS,run)')
结果都只能包含run记录，不能查到包含“ran”“running”的记录

修改并加载同义词库后：execute sys.sp_fulltext_load_thesaurus_file 1033;使用查询：
SELECT * FROM COMPANY WHERE CONTAINS(FMARK,'FORMSOF(INFLECTIONAL, run)')
结果也只能查到包含“run”的记录，修改的同义词库tsenu.xml没有起作用


求大神指导！！！

[hery2002]

你的第二个语句应该是没有问题的，在AW2012上测试结果如下， ride, rides, ridden,ridding都可以抓出来。

USE AdventureWorks2012;
GO
SELECT Description
FROM Production.ProductDescription
WHERE CONTAINS(Description, ' FORMSOF (INFLECTIONAL, ride) ');
GO
/*
Description
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Suitable for any type of riding, on or off-road. Fits any budget. Smooth-shifting with a comfortable ride.
Serious back-country riding. Perfect for all levels of competition. Uses the same HL Frame as the Mountain-100.
Entry level adult bike; offers a comfortable ride cross-country or down the block. Quick-release hubs and rims.
A true multi-sport bike that offers streamlined riding and a revolutionary design. Aerodynamic design lets you ride with the pros, and the gearing will conquer hilly roads.
Alluminum-alloy frame provides a light, stiff ride, whether you are racing in the velodrome or on a demanding club ride on country roads.
This bike is ridden by race winners. Developed with the Adventure Works Cycles professional race team, it has a extremely light heat-treated aluminum frame, and steering that allows precision control.
All-occasion value bike with our basic comfort and safety features. Offers wider, more stable tires for a ride around town or weekend trip.
The plush custom saddle keeps you riding all day,  and there's plenty of space to add panniers and bike bags to the newly-redesigned carrier.  This bike has stability when fully-loaded.
Aerodynamic rims for smooth riding.
A light yet stiff aluminum bar for long distance riding.
Expanded platform so you can ride in any shoes; great for all-around riding.
A stable pedal for all-day riding.
Excellent aerodynamic rims guarantee a smooth ride.
Anatomic design for a full-day of riding in comfort. Durable leather.
New design relieves pressure for long rides.
Cut-out shell for a more comfortable ride.
Lightweight carbon reinforced  for an unrivaled ride at an un-compromised weight.
The LL Frame provides a safe comfortable ride, while offering superior bump absorption in a value-priced aluminum frame.
Lightweight butted aluminum frame provides a more upright riding position for a trip around town.  Our ground-breaking design provides optimum comfort.
The HL aluminum frame is custom-shaped for both good looks and strength; it will withstand the most rigorous challenges of daily riding. Men's version.
Affordable light for safe night riding - uses 3 AAA batteries
Warm spandex tights for winter riding; seamless chamois construction eliminates pressure points.

*/

[初学者--]

@hery2002 我将你的数据添加到数据库中，但是还是只能搜到“ride” 在创建全文索引的时候，有什么注意事项吗？

[初学者--]

@hery2002 thank you 问题找到了，对全文索引列的段字符语言设置存在问题，设置简体中文，查询英文会有问题