Skip to content

Instantly share code, notes, and snippets.

@ststeiger
Created October 18, 2023 14:51
Show Gist options
  • Save ststeiger/e337191e7b6ceee5a7e960908718271e to your computer and use it in GitHub Desktop.
Save ststeiger/e337191e7b6ceee5a7e960908718271e to your computer and use it in GitHub Desktop.
List of .NET Cultures in SQL
SELECT
SYSLANG_LCID
-- ,SYSLANG_Name
,SYSLANG_IetfLanguageTag AS IETF
--,SYSLANG_TwoLetterISOLanguageName
--,SYSLANG_ThreeLetterISOLanguageName
--,SYSLANG_ThreeLetterWindowsLanguageName
,SYSLANG_EnglishName
,SYSLANG_NativeName
-- ,SYSLANG_DisplayName
,dbo.udf_TitleCaseN(SYSLANG_NativeName) AS NativeName_TitleCase
,SYSLANG_Calendar
,SYSLANG_IsRightToLeft
,SYSLANG_DateSeparator
,SYSLANG_ListSeparator
,SYSLANG_NumberDecimalSeparator
,SYSLANG_NumberGroupSeparator
,SYSLANG_CurrencyGroupSeparator
,*
FROM T_SYS_Language
WHERE (1=1)
AND SYSLANG_EnglishName LIKE '%malt%'
-- AND SYSLANG_IsNeutralCulture = 1
-- AND SYSLANG_Calendar <> 'System.Globalization.GregorianCalendar' -- Arabic (Saudi), Divehi (Maldives), Dari&Pashto (Afghanistan), Thai
-- AND SYSLANG_NumberGroupSeparator <> SYSLANG_CurrencyGroupSeparator -- Sweden, Afghani, Tamazight
-- AND SYSLANG_IsRightToLeft = 1 -- Arabic, Divehi (Maldives), Persian (Iran), Hebrew (Israel), Syriac (Syria), Urdu (Islamic Republic of Pakistan)
-- AND SYSLANG_Name <> SYSLANG_IetfLanguageTag
ORDER BY IETF
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment