character_set_client is the session value of
the character_set_client system
variable when the routine was created.
collation_connection is the session value of
the collation_connection system
variable when the routine was created. Database
Collation is the collation of the database with which
the routine is associated.