CODE EXAMPLE FOR SQL

mysql get character set

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