MySQL Collation and Character Set export to CSV

mysql_collation_and_character_sets.sql

MySQL Collation Checkup

SELECT @@character_set_database, @@collation_database
INTO OUTFILE '/tmp/table_defaults_charset.csv' 
FIELDS TERMINATED BY ',' 
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n';

SELECT * FROM information_schema.schemata
INTO OUTFILE '/tmp/schema_charset.csv' 
FIELDS TERMINATED BY ',' 
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n';

SELECT t.table_name, ccsa.character_set_name, ccsa.collation_name
FROM 
  information_schema.TABLES t,
  information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
WHERE 
  ccsa.collation_name = t.table_collation
  AND t.table_schema = "YOUR_NAME_HERE"
ORDER BY 
  t.table_name
  INTO OUTFILE '/tmp/table_charset.csv' 
  FIELDS TERMINATED BY ',' 
  OPTIONALLY ENCLOSED BY '"'
  LINES TERMINATED BY '\n';

SELECT table_name, column_name, character_set_name, collation_name, column_type
FROM information_schema.columns
WHERE table_schema = "YOUR_NAME_HERE"
ORDER BY table_name, column_name
INTO OUTFILE '/tmp/column_charset.csv' 
FIELDS TERMINATED BY ',' 
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n';