DBCS String Comparisons (Level 4)

Installing SQL Server

Installing SQL Server
DBCS String Comparisons (Level 4)
SQL Server 6.x SQL Server 2000
When comparing DBCS space characters, the Unicode A140 space character (U-A140) was not equal to the Unicode 0020 (U-0020) space character. Comparisons involving the Unicode A140 space character (U-A140) are now equivalent to the Unicode 0020 (U-0020) space character.

Expect different results as compared to earlier versions of SQL Server when comparing DBCS space characters.