-#define MY_CS_NAME_SIZE                        32

+#define MY_CS_CHARACTER_SET_NAME_SIZE   32

+#define MY_CS_COLLATION_NAME_SIZE       64

SELECT table_schema, table_name, column_name, column_type

FROM information_schema.columns WHERE column_name LIKE '%colla%';

+--------------------+---------------------------------------+------------------------+-------------+

| table_schema       | table_name                            | column_name            | column_type |

+--------------------+---------------------------------------+------------------------+-------------+

| mysql              | proc                                  | collation_connection   | char(32)    |

| mysql              | proc                                  | db_collation           | char(32)    |

| mysql              | event                                 | collation_connection   | char(32)    |

| mysql              | event                                 | db_collation           | char(32)    |

| information_schema | CHARACTER_SETS                        | DEFAULT_COLLATE_NAME   | varchar(64) |

| information_schema | COLLATIONS                            | COLLATION_NAME         | varchar(64) |

| information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | COLLATION_NAME         | varchar(64) |

| information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | FULL_COLLATION_NAME    | varchar(64) |

| information_schema | COLUMNS                               | COLLATION_NAME         | varchar(64) |

| information_schema | EVENTS                                | COLLATION_CONNECTION   | varchar(64) |

| information_schema | EVENTS                                | DATABASE_COLLATION     | varchar(64) |

| information_schema | PARAMETERS                            | COLLATION_NAME         | varchar(64) |

| information_schema | ROUTINES                              | COLLATION_NAME         | varchar(64) |

| information_schema | ROUTINES                              | COLLATION_CONNECTION   | varchar(64) |

| information_schema | ROUTINES                              | DATABASE_COLLATION     | varchar(64) |

| information_schema | SCHEMATA                              | DEFAULT_COLLATION_NAME | varchar(64) |

| information_schema | STATISTICS                            | COLLATION              | varchar(1)  |

| information_schema | TABLES                                | TABLE_COLLATION        | varchar(64) |

| information_schema | TRIGGERS                              | COLLATION_CONNECTION   | varchar(64) |

| information_schema | TRIGGERS                              | DATABASE_COLLATION     | varchar(64) |

| information_schema | VIEWS                                 | COLLATION_CONNECTION   | varchar(64) |

+--------------------+---------------------------------------+------------------------+-------------+

SET NAMES 'utf8mb3' COLLATE 'utf8mb3_uca1400_swedish_nopad_ai_ci';

CREATE FUNCTION f1() RETURNS INT RETURN 1;

ERROR 1607 (HY000): Cannot create stored routine `f1`. Check warnings

SHOW WARNINGS;

+---------+------+--------------------------------------------------------------+

| Level   | Code | Message                                                      |

+---------+------+--------------------------------------------------------------+

| Warning | 1265 | Data truncated for column 'collation_connection' at row 3226 |

| Error   | 1607 | Cannot create stored routine `f1`. Check warnings            |

+---------+------+--------------------------------------------------------------+