Hello,I have a table with products. In this table there is a column with some information about the product, like product name, number, etc..For example:CR1AC1EM1SP10535PG5 008498 31755 008498 4015080317555 My productThe bold part is the number that I want to search for using the ContainsTable keyword. My query look like this: SELECT top 10 * FROM MyTable INNER JOIN containstable(MyTable, ColumnProductInfo, '"4015080317555"', 1000) FTS ON MyTable.ColumnUniqueKey = FTS.[key]
When I run this query it doesn't only return the product with number 4015080317555, but it returns all products of which the product number start with 401508 (the first 6 digits).The fulltext column has the Neutral language. When I change the language to English and rebuild the index, it returns only product 4015080317555 which is correct. This is what I would expect with the Neutral language as well.I don't like to use the English language since the product names are in Dutch, but both the Neutral as the Dutch language don't work correctly.When I change the query so that I put an * in place of the last 5 in the product number, then I do get the correct result: SELECT top 10 * FROM MyTable INNER JOIN containstable(MyTable, ColumnProductInfo, '"401508031755*"', 1000) FTS ON MyTable.ColumnUniqueKey = FTS.[key]
I prefer do use the Dutch (or Neutral) language, because I don't know what other problems I could run into if I change to English (the database already runs at customers).What is going wrong and what can I do to make this query work for the Dutch or Neutral language?Any help is greatly appreciated.~Jasper
Sql Server 2008 Fulltext problem
Posted - 2010-06-01 : 02:53:27