demonfox (3/19/2013)

It seems to use ISO-639-2 some of the time, but not always: for example bgr, chs, cht, and enu are not in ISO-639-2 but are 3 letter language codes used by MS.

here is a discussion reference and an included further references .. I think, this might the standard followed by ms in sql server.. but, then again , a guess 😉

http://social.msdn.microsoft.com/Forums/en-US/wpf/thread/efa9b596-3bc4-4be7-aeeb-4d97ad31f1dd

http://msdn.microsoft.com/en-us/library/system.globalization.cultureinfo.threeletterisolanguagename.aspx%5B/url%5D%5B/quote%5D

Those look useful - presumably the "ThreeLetterISOLanguageName" property in the CultureInfo object is not actually what it is called but what MS uses (which is sometimes but not always a three letter ISO language code).

Isn't it wonderful that you have to grub about either in the registry or in .NET objects to discover information that ought to be properly documented? And that for all we know grubbing about in the two places may deliver different answers? And that even the number of SQL-Sever supported languages (documented clearly as 33 in BoL) is perhaps 40 or 41 or 44 or 48 depending on which web page one looks at and whether one believes the directry entries installed with SQL Server instead of BoL or some other MSDN web page?