Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am using SQL Server fulltext containstable and the column which is indexed has collation Czech_CS_AS, so why when I have word "byt" it returns records with word "být" too. I thought that the collation should solve this, but obviously I have to set something else, but I don't know what

share|improve this question

migrated from stackoverflow.com Sep 22 '12 at 8:17

This question came from our site for professional and enthusiast programmers.

Did you specify the accent sensitivity attribute of the catalog itself (by default it should match)? –  Alex K. Sep 21 '12 at 13:15
Of course I didn't, I totally forgot about the catalog,I am stupid. Thanks a lot –  david Sep 21 '12 at 13:26
If you change the accent sensitivity setting, you will need to rebuild the catalog. –  Pete Carter Sep 24 '12 at 18:20

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.