`information_schema.columns.collation_name`

mysql

type: VARCHAR NULL

5.7-8

type: NULL

Note:

Collation if a non-binary string data type, otherwise NULL.

5.1-10.8

type: VARCHAR(32) NULL

Note:

The name of the collation of a string column.

4-6.1

type: SQL_IDENTIFIER NULL

Note:

Name of the collation of the column, null if default or the data type of the column is not collatable

10-15

type: SQL_IDENTIFIER

Note:

Name of the collation of the column, null if default or the data type of the column is not collatable

9.2-9.6

Note:

Not yet implemented

9.1

Note:

Applies to a feature not available in PostgreSQL

7.4-9

type: unknown

Note:

Name of the collation; NULL if the default collation is used, or if data_type is not collatable.

type: NVARCHAR(128) NULL

Note:

Returns the unique name for the collation if the column is character data or text data type. Otherwise, NULL is returned.