Collation Info (Reference)

collation, encoding, code page, locale, sorting, comparison, LCID, T-SQL, TSQL, SQL Server 2024-4-19 9-18

Collations Info

Home Concepts Answers Reference Microsoft Connect Contact

collation, encoding, code page, locale, sorting, comparison, LCID, T-SQL, TSQL, SQL Server

— Reference —

Category	Commands & Functions	Tables & Views
SQL Server	COLLATE COLLATIONPROPERTY TERTIARY_WEIGHTS SERVERPROPERTY DATABASEPROPERTYEX sp_helpsort	sys.fn_helpcollations

Windows	DBCS/Unicode Mapping Tables Sort Order for Selected Languages Code Page Support in Microsoft Windows Code Pages Primary Language IDs LCID Structure Product Behavior Code Page Identifiers

.NET	CultureInfo Class char Char Struct System.Globalization Namespace StringInfo Class Encoding Class TextInfo Class CharUnicodeInfo Class

DOS	chcp

General	ICU Collation Demo The Unicode Consortium Unicode Utilities: UnicodeSet Unicode Utilities: Character Properties Unicode® character table EmojiPedia Unicode® Technical Standard #51: UNICODE EMOJI Full Emoji List

collation, encoding, code page, locale, sorting, comparison, LCID, T-SQL, TSQL, SQL Server 2024-4-19 9-18