mirror of
https://github.com/MariaDB/server.git
synced 2025-07-02 01:18:12 +02:00
![]() Adding a new column in INFORMATION_SCHEMA.COLLATIONS: PAD_ATTRIBUTE ENUM('PAD SPACE','NO PAD') and a new column Pad_attribute into SHOW COLLATION. The new column has been added after SORTLEN but before COMMENT. This order is compatible with MySQL-8.0 order, with the exception that MariaDB has an extra last column COMMENT: MariaDB [test]> desc information_schema.collations; +--------------------+----------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------+----------------------------+------+-----+---------+-------+ | COLLATION_NAME | varchar(64) | NO | | NULL | | | CHARACTER_SET_NAME | varchar(32) | YES | | NULL | | | ID | bigint(11) | YES | | NULL | | | IS_DEFAULT | varchar(3) | YES | | NULL | | | IS_COMPILED | varchar(3) | NO | | NULL | | | SORTLEN | bigint(3) | NO | | NULL | | | PAD_ATTRIBUTE | enum('PAD SPACE','NO PAD') | NO | | NULL | | | COMMENT | varchar(80) | NO | | NULL | | +--------------------+----------------------------+------+-----+---------+-------+ The new Pad_attribute in SHOW COLLATION has been added as the last column. This is also compatible with MySQL: MariaDB [test]> show collation like 'utf8mb4_bin'; +-------------+---------+------+---------+----------+---------+---------------+ | Collation | Charset | Id | Default | Compiled | Sortlen | Pad_attribute | +-------------+---------+------+---------+----------+---------+---------------+ | utf8mb4_bin | utf8mb4 | 46 | | Yes | 1 | PAD SPACE | +-------------+---------+------+---------+----------+---------+---------------+ |
||
---|---|---|
.. | ||
r | ||
t | ||
combinations | ||
disabled.def |