SQL Server/T-SQL Tutorial/System Functions/fn helpcollations

Viewing Collation Metadata fn_helpcollations

   <source lang="sql">

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></source>