Tell me more ×
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.
up vote 2 down vote favorite

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

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

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

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.