Contents tagged with Collations

  • Revised: Difference between collation SQL_Latin1_General_CP1_CI_AS and Latin1_General_CI_AS

    Tags: Collations, Unicode, Performance, varchar, nvarchar

    This is a revised post of an original article that I first published in December. Even though I thought that I was very meticulous in my research, something was pointed out to me that I was totally unaware of - Unicode character expansions. So apologies to the community with regard the first article that I published as some of the original content could have been misleading. Here is a new revised article that explains character expansions and how it can affect the comparison of data with these … more