Search code examples
t-sqlsql-server-2012containstable

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.


Solution

  • 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.