Mega Code Archive

 

Categories / MSSQL Tutorial / System Functions

 

Viewing Collation Metadata fn_helpcollations

3> 4> SELECT description 5> FROM fn_helpcollations() 6> WHERE name = 'SQL_Latin1_General_CP1_CI_AS' 7> GO description ------------------------------------------------------------------------------------------------------------------------ ---------------------------------------- Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server  Sort Order 52 on Code Page 1252 for non-Unicode Data (1 rows affected) 1>