question

Jasper avatar image
Jasper asked

Sql Server 2008 Fulltext problem

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 product

The 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-2008indexingfull-text
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.