diff options
Diffstat (limited to 'mysql-test/r/character_set_server_func.result')
-rw-r--r-- | mysql-test/r/character_set_server_func.result | 65 |
1 files changed, 0 insertions, 65 deletions
diff --git a/mysql-test/r/character_set_server_func.result b/mysql-test/r/character_set_server_func.result deleted file mode 100644 index 3731f27adae..00000000000 --- a/mysql-test/r/character_set_server_func.result +++ /dev/null @@ -1,65 +0,0 @@ -'#--------------------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; |