Collection of methods for changing the default Character Set of MySQL

Change the default Character SET Method of MySQL. method 1. Use the SET syntax to specify the default character SET. If "GLOBAL" is not added, it is only valid for this session www.2cto.com SET [GLOBAL] character_set_client = utf8; SET [GLOBAL] character_set_connection = utf8; SET [GLOBAL] character_set_database = utf8; SET [GLOBAL] character_set_results = utf8; SET [GLOBAL] character_set_server = utf8; method 2, also use SET syntax, set names 'utf8' only for this session; www.2cto.com method 3. directly modify my. ini, add a line of content, and then restart MySQL to make the global effect default-character-set = utf8