Reader Georges asked the other day via the Contact link:
Do you have a list of the national standards supported by the various collations that Windows and SQL Server and .NET support?
And similarly, regular reader Ivan Petrov asked in the Suggestion Box:
Hi Michael,
Do you have a list with the supported Keyboard layouts by Windows and the corresponding standard documents in which they are defined with their full document numbers and titles ?
I mean national standards like ANSI (US), DIN (DE), GOST (RU) and etc. or any other Standards like ISO, EN and etc. or Norm documents .
I will be very grateful to you if you post such a list as attachment to a post.
Regards,
Ivan.
Funny having two such similar questions in two areas so completely different from each other, no? :-)
The answer is really the same for both questions (fortunately or unfortunately, depending on your point of view)....
And that is no such list really exists.
Both keyboards and collations are attempts by Microsoft to capture language and market requirements and include them in Windows, and although standards are an important source of inspiration for each, the connection between them is seldom so complete that one could really claim that they are 100% implementations (as an example, some National collation standards tend to specify behavior for punctuation as well as language, while Windows does not tend to change its punctuation-specific behavior for individual locales).
Also (and this is me just speculating), if we documented such a direct connection via a compliance claim, Microsoft could be required to break its own stability guarantees regarding results anytime there was such a difference between the MS implementation and the one in the standard -- and changes in the standard would lead to new sorts and keyboards being needed whether they are used in country or nor....
Instead by using standards as "important, knowledgeable informants" to be considered alongside other sources of information, the appropriate distance is kept that allows the unique technical factors affecting Microsoft platforms to be taken into account without leading to conformance problems....
In addition, I am kind of being polite by implying that National standards for keyboards and collation differ from Microsoft only in such details and that they are completely valid descriptions with no problems in them; there are definitely times where (were I a less polite version of myself) I could easily start blasting countries or regions for flaws within their standards, causing all sorts of incidents.
And of course there are the times (especially in keyboards, especially with MSKLC available) that a government standard is the source for the layout that we ship which differs from their actual standard in some way (we do not do compliance testing on such things since of course it isn't our job to make sure they are following their own standards in such cases!), and putting direct connections on a web page (even a non-official page such as blogs are!) could easily get Microsoft into an uncomfortable support situation.
So I apologize to both Ivan and Georges for not having such lists (or similar lists for code pages that I to put up here). Sometimes the best way to not find oneself holding onto something nasty is to not pick it up in the first place....
This post brought to you by dž (U+01c6, aka LATIN SMALL LETTER DZ WITH CARON)