Name
collation_list — List current collations
Common Usage
PRAGMA collation_list;
Description
The collation_list pragma lists all the active
collations in the current database connection. This pragma will
return a two-column table with one row per active
collation.
| Column name | Column type | Meaning |
|---|---|---|
seq
| Integer | Collation sequence number |
name
| Text | Name of collation |
Unless an application has defined
additional collations, the list will be limited to the built-in
collations NOCASE, RTRIM, and BINARY.
See Also
database_list, sqlite3_create_collation() [C API, Ap G]
Get Using SQLite now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
