Microsoft SQL Server 2005 fulltext search case-sensitive

Microsoft SQL Server 2005’s fulltext search is supposed to be case-insensitive. Supposed to be. But actually, it isn’t. For example, the statement:

CONTAINSTABLE(tbl, column, FORMSOF(INFLECTIONAL, x-710))

yields no results, but with a capital “X” 

CONTAINSTABLE(tbl, column, FORMSOF(INFLECTIONAL, X-710))

yields 22 results in my database. Searching around the MS forums a bit I get a feeling it has something todo with locale-specific wordbreaking, but who really cares.

Lesson learnt: transform your fulltext search term to upper case to prevent unpredictable behavior.

Advertisements

One Response to “Microsoft SQL Server 2005 fulltext search case-sensitive”

  1. clint Says:

    Had the same issue until I read your post; mine was the other way around though. I converted all searches to lower case and that solved the issue.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: