MySql sets the default value'collation_connection'

created at 07-27-2021 views: 5

MySql set the default value'collation_connection'

SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci

View the execution results:

SHOW VARIABLES WHERE Variable_name LIKE 'character_set_%' OR Variable_name LIKE 'collation%';

RESULT

KEYVALUE
character_set_clientutf8mb4
character_set_connectionutf8mb4
character_set_databaseutf8mb4
character_set_filesystembinary
character_set_resultsutf8mb4
character_set_serverutf8mb4
character_set_systemutf8
character_sets_dir/www/server/mysql/share/charsets/
collation_connectionutf8mb4_unicode_ci
collation_databaseutf8mb4_unicode_ci
collation_serverutf8mb4_unicode_ci
created at:07-27-2021
edited at: 07-27-2021: