• to get the collation of a column of a table

    select COLLATION_NAME

    from information_schema.columns

    -- you complete this bit as necessary

    where table_name like '%'

    and column_name like '%'

    or have I missed something?

    pcd