by Michael S. Kaplan, published on 2007/12/08 10:16 -05:00, original URI: http://blogs.msdn.com/b/michkap/archive/2007/12/08/6669846.aspx
You might have started to sense a pattern developing here with the last few posts in this series:
That last post pointed out two characters that would be missing if you have a width sensitive collation.
and now this post is going to talk about accent sensitivity and it's impact.
This will add over two dozen characters like the following ones:
and more! All of which have some sort of "Z-ish" quality about them, none of which will be handled by the ranges defined thus far according to the documentation for SAL Server if your application is run in the context of an accent sensitive collation.
Oops.
You get the point - this odd combination of actual linguistic characters used in language, phonetic symbols, and circled/parenthesize letters have a fundamental identity that users would expect to sort somewhere not far from the Z by default.
SQL Server does that well -- how about your application with your LIKE range? :-)
And just in case you thought I was done, it gets worse tomorrow....
This post brought to you by ⒵ (U+24b5, aka PARENTHESIZED LATIN SMALL LETTER Z, the last Z-like thing in the Latin script....)
referenced by