CODEWITHSUNDEEP
t-sqlsql-server-2012containstable
Honza K.
Honza K.

Reputation: 115

How to accent insensitive fulltext search in Containstable on MS SQL Server

I'm trying to update stored procedure to be able compare data accent insensitive. Current stored procedure use Containstable for fulltext search, but comparison is accent sensitive. Is there any chance to set collation (e.g. Latin1_General_CI_AI) for containstable?

Collation of db is accent sensitive.

I'm using MS SQL server 2012 Express.

Upvotes: 1

Views: 1987

Answers (1)

Andrey Nikolov
Andrey Nikolov

Reputation: 13440

You can change the accent sensitivity of the full text catalog:

ALTER FULLTEXT CATALOG [MyFullTextCatalog] REBUILD WITH ACCENT_SENSITIVITY = OFF

However, note that this is a global change, not only for this particular store procedure.

Upvotes: 5

Related Questions