Edit File: character_set_server_func.result
'#--------------------FN_DYNVARS_009_01-------------------------#' SET @global_character_set_server = @@global.character_set_server; SET @session_character_set_server = @@session.character_set_server; SET @@global.character_set_server = utf8; 'connect (con1,localhost,root,,,,)' 'connection con1' SELECT @@global.character_set_server; @@global.character_set_server utf8 SELECT @@session.character_set_server; @@session.character_set_server utf8 '#--------------------FN_DYNVARS_009_02-------------------------#' 'connection default' '---global character_set_server should not effects current connection---' SET @@global.character_set_server = utf8; CREATE DATABASE db1; USE db1; SHOW CREATE DATABASE db1; Database Create Database db1 CREATE DATABASE `db1` /*!40100 DEFAULT CHARACTER SET latin1 */ DROP DATABASE db1; select @@character_set_database; @@character_set_database latin1 '---session character_set_server should effects current connection---' SET @@session.character_set_server = utf8; CREATE DATABASE db1; USE db1; SHOW CREATE DATABASE db1; Database Create Database db1 CREATE DATABASE `db1` /*!40100 DEFAULT CHARACTER SET utf8 */ DROP DATABASE db1; select @@character_set_database; @@character_set_database utf8 '----test with new connection----' 'connect (con1,localhost,root,,,,)' 'connection con1' SELECT @@session.character_set_server; @@session.character_set_server utf8 '----------character set not specified---------' CREATE DATABASE db1; USE db1; SHOW CREATE DATABASE db1; Database Create Database db1 CREATE DATABASE `db1` /*!40100 DEFAULT CHARACTER SET utf8 */ DROP DATABASE db1; SELECT @@character_set_database; @@character_set_database utf8 '----------ascii character set specified----------' CREATE DATABASE db1 character set ascii; USE db1; SHOW CREATE DATABASE db1; Database Create Database db1 CREATE DATABASE `db1` /*!40100 DEFAULT CHARACTER SET ascii */ DROP DATABASE db1; select @@character_set_database; @@character_set_database utf8 'connection default;' SET @@global.character_set_server = @global_character_set_server; SET @@session.character_set_server = @session_character_set_server;
Back to File Manager