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.