Some additional info from http://msdn.microsoft.com/en-us/library/ms143726.aspx
The following table compares the behavior of some string functions and string operators when they use supplementary characters with and without a SC collation.
With an SC Collation - LEN - The UTF-16 surrogate pair is counted as a single codepoint.
Without an SC Collation - LEN - The UTF-16 surrogate pair is counted as two codepoints.
commented on Jun 20 2013 3:06AM