How to check the Character set and Collation in Mysql Server

1. SHOW CHARACTER SET WHERE CHARSET = 'utf8';

2. SHOW VARIABLES LIKE 'char%';

3. SHOW VARIABLES LIKE 'coll%';

4. use db_name;

    SELECT @@character_set_database, @@collation_database;

5. select * from information_schema.routines where routine_schema   not in                               ('information_schema','performance_schema','mysql','sys') and DATABASE_COLLATION not in ('utf8_general_ci');

 

 6. select * from information_schema.routines where routine_schema   not in ('information_schema','performance_schema','mysql','sys')

 and COLLATION_CONNECTION not in ('utf8_general_ci');

 

  7. select * from information_schema.routines where routine_schema   not in ('information_schema','performance_schema','mysql','sys')

 and   CHARACTER_SET_CLIENT<>'utf8';