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:


yields no results, but with a capital “X” 


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.


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: Logo

You are commenting using your 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: