SHOW COLLATION

Precautions

N/A

Function

Displays the character order of all supported servers.

Syntax

SHOW COLLATION [LIKE 'pattern' | WHERE expr]

Parameter Description

WHERE expr

Filter expressions.
LIKE 'pattern'

The pattern regular expression matches the sorted name.

Returns The Result Set

Field	Description	Note
collation	Sorting set names
charset	Character sets associated with sorted sets
id	Description of the character set	This field corresponds to the OID of the row corresponding to the row in the pg_collation table
default	Whether it is a sorted set corresponding to a character set	MogDB has no default sorting, and the contents of this field are null
compiled	Whether the sort set is compiled or not	The value of this field is Yes
sortlen	Memory size required when sorting character sets	The value of this field is NULL

Examples

MogDB=# SHOW COLLATION LIKE 'aa%';
    collation     | charset |  id   | default | compiled | sortlen
------------------+---------+-------+---------+----------+----------
 aa_DJ            | utf8    | 13450 |         | Yes      |
 aa_DJ            | latin1  | 13451 |         | Yes      |
 aa_DJ.iso88591   | latin1  | 13452 |         | Yes      |
 aa_DJ.utf8       | utf8    | 13453 |         | Yes      |
 aa_ER            | utf8    | 13454 |         | Yes      |
 aa_ER.utf8       | utf8    | 13455 |         | Yes      |
 aa_ER.utf8@saaho | utf8    | 13456 |         | Yes      |
 aa_ER@saaho      | utf8    | 13457 |         | Yes      |
 aa_ET            | utf8    | 13458 |         | Yes      |
 aa_ET.utf8       | utf8    | 13459 |         | Yes      |
(10 rows)