我的CONTAINSTABLE语句搜索英文内容，有数据，没有结果

Question

我的CONTAINSTABLE语句搜索英文内容，有数据，没有结果（中文没有问题）SELECT top 10 BB.* FROM 
(SELECT A.KL_ID,A.KL_Name FROM [orangeok].[dbo].[Keyword_Library] as A 
JOIN (SELECT MIN(KL_ID) AS KL_ID,KL_Name FROM [orangeok].[dbo].[Keyword_Library] GROUP BY KL_Name ) B 
ON (A.KL_ID=B.KL_ID AND A.KL_Name like B.KL_Name)) as BB 
  JOIN CONTAINSTABLE(Keyword_Library,KL_Name,'ISABOUT("*Lancome*" weight(1.0),"L" weight(0.9),"a" weight(0.7))') as PP on (BB.KL_ID = PP.[KEY] AND len(BB.KL_Name) <= 10) order by PP.RANK desc

Answer 1

'ISABOUT("*Lancome*" weight(1.0),"L" weight(0.9),"a" weight(0.7))'-->N'ISABOUT("*Lancome*" weight(1.0),"L" weight(0.9),"a" weight(0.7))'

Answer 2

试试
select * from CONTAINSTABLE(Keyword_Library,KL_Name,'ISABOUT("*Lancome*" weight(1.0),"L" weight(0.9),"a" weight(0.7))')
有没有结果.