information_schema.routine_columns.collation_name

Note:

Returns the unique name for the sort order if the column is character data or text data type. Otherwise, returns NULL.