CODE EXAMPLE FOR SQL

mysql show charset

SELECT default_character_set_name FROM information_schema.SCHEMATA 
WHERE schema_name = "yourdbnamehere";