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
2  
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
add comment

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

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

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.