Why I write so many collation topics?

  • Article

   You may wonder why I keep writing collation topics in my blogs.  I found our Books Online topics related to collation is not so clearly enough, and sometime it confuse our reader.  I intend to present my idea related to collation in a series of blogs, and finally I want group all these topics together to draw a clear picture about collation. My blogs will try to answer following question in details:

  • How I should choose a collation?
  • What is the different between collation A and B?
  • How collation impact the behavior of query, such as string functions,  variables assignment?
  • Best practices for using SQL Server's collation.

 Again, I strong suggest your guys send my comments or collation related question to me,   If I can not answer, I will find some language expert to answer this, and I will also share the answer as well.