What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 134 Stack Exchange communities.

What is the collation used for StackOverflow trilogy databases?

The intention of this question is optimize how one can do a search within SO sites.

My guess is that, collation is set to SQL_Latin1_General_CP1_CI_AI but I would like to know if case sensitivity or accents matter or not.

share|improve this question
    
Does this question belong here or on SO? hmm... –  Sung Kim Oct 11 '09 at 19:20
2  
Here, for sure. –  jjnguy Oct 12 '09 at 5:00

1 Answer 1

up vote 5 down vote accepted

Collation is currently set to SQL_Latin1_General_CP1_CS_AS - the "why" is lost in antiquity.

We'll probably change it over to a case-insensitive collation at some point, but it's not a concern right now.

However, we're using SQL Server's Full Text Search, which is case-insensitive*, so the database collation shouldn't matter.

* only place I could find MS saying it's case-insensitive: http://msdn.microsoft.com/en-us/library/ms187787.aspx (search for sensitive)

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .