A clause of the query contained only ignored words.

• praveen kumar-491230

  Old Hand

  Points: 363

  More actions

  October 24, 2007 at 5:28 am

  #62477

  Hi,

  I have a table on SQL server 2000 in which store hindi language data and table has FullText catalogs for faster searching but when i execute following query

  select * from Titlelanguage where contains(languageTitle, N'लक्ष्मी')

  SQL server returns me following error

  "A clause of the query contained only ignored words."

  One thing i want to tell u that i have clear data in noise.enu table.

  Plz help me to overcome this problem

  Thanks in advance

  Praveen Rohilla

• VaiydeyanathanVS

  Hall of Fame

  Points: 3053

  More actions

  October 24, 2007 at 5:38 am

  #744889

  try this ........

  1) http://msdn2.microsoft.com/en-us/library/aa902644(sql.80).aspx

  2) http://download.microsoft.com/download/c/f/3/cf382f77-0c44-4a4b-b437-58718bc6998e/Unicode%20and%20Collation%20Support%20in%20Microsoft%20SQL%20Server_c.ppt