1'#--------------------FN_DYNVARS_009_01-------------------------#' 2SET @global_character_set_server = @@global.character_set_server; 3SET @session_character_set_server = @@session.character_set_server; 4SET @@global.character_set_server = utf8; 5connect con1,localhost,root,,,,; 6connection con1; 7SELECT @@global.character_set_server; 8@@global.character_set_server 9utf8 10SELECT @@session.character_set_server; 11@@session.character_set_server 12utf8 13disconnect con1; 14'#--------------------FN_DYNVARS_009_02-------------------------#' 15connection default; 16'--global character_set_server should not effects current connection--' 17select @@character_set_database=@@character_set_connection; 18@@character_set_database=@@character_set_connection 191 20SET @@global.character_set_server = utf8; 21CREATE DATABASE db1; 22USE db1; 23SHOW CREATE DATABASE db1; 24Database Create Database 25db1 CREATE DATABASE `db1` /*!40100 DEFAULT CHARACTER SET latin1 */ 26DROP DATABASE db1; 27select @@character_set_database; 28@@character_set_database 29latin1 30'---session character_set_server should effects current connection---' 31SET @@session.character_set_server = utf8; 32CREATE DATABASE db1; 33USE db1; 34SHOW CREATE DATABASE db1; 35Database Create Database 36db1 CREATE DATABASE `db1` /*!40100 DEFAULT CHARACTER SET utf8 */ 37DROP DATABASE db1; 38select @@character_set_database; 39@@character_set_database 40utf8 41'----test with new connection----' 42connect con1,localhost,root,,,,; 43connection con1; 44SELECT @@session.character_set_server; 45@@session.character_set_server 46utf8 47'----------character set not specified---------' 48CREATE DATABASE db1; 49USE db1; 50SHOW CREATE DATABASE db1; 51Database Create Database 52db1 CREATE DATABASE `db1` /*!40100 DEFAULT CHARACTER SET utf8 */ 53DROP DATABASE db1; 54SELECT @@character_set_database; 55@@character_set_database 56utf8 57'----------ascii character set specified----------' 58CREATE DATABASE db1 character set ascii; 59USE db1; 60SHOW CREATE DATABASE db1; 61Database Create Database 62db1 CREATE DATABASE `db1` /*!40100 DEFAULT CHARACTER SET ascii */ 63DROP DATABASE db1; 64select @@character_set_database; 65@@character_set_database 66utf8 67disconnect con1; 68connection default; 69SET @@global.character_set_server = @global_character_set_server; 70SET @@session.character_set_server = @session_character_set_server; 71