diff options
author | Georgi Kodinov <joro@sun.com> | 2009-01-30 15:44:49 +0200 |
---|---|---|
committer | Georgi Kodinov <joro@sun.com> | 2009-01-30 15:44:49 +0200 |
commit | 87eb2cb938382b545158987a1cc6bc170588db3a (patch) | |
tree | a6a00e2376ec5327aa29d5a5b2441a06f8d146d4 /mysql-test/suite/sys_vars/r/character_set_client_func.result | |
parent | 093a6dd90e12ca41e7e415f57f5a91181bf1959e (diff) | |
parent | f7a24d72dc7a86341da4634f6d1a71f1ea77000b (diff) | |
download | mariadb-git-87eb2cb938382b545158987a1cc6bc170588db3a.tar.gz |
merged 5.1-main -> 5.1-bugteam
Diffstat (limited to 'mysql-test/suite/sys_vars/r/character_set_client_func.result')
-rw-r--r-- | mysql-test/suite/sys_vars/r/character_set_client_func.result | 38 |
1 files changed, 38 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/r/character_set_client_func.result b/mysql-test/suite/sys_vars/r/character_set_client_func.result new file mode 100644 index 00000000000..087db21639b --- /dev/null +++ b/mysql-test/suite/sys_vars/r/character_set_client_func.result @@ -0,0 +1,38 @@ +'#--------------------FN_DYNVARS_010_01-------------------------#' +SET @global_character_set_client = @@global.character_set_client; +SET @session_character_set_client = @@session.character_set_client; +SET @@global.character_set_client = utf8; +'connect (con1,localhost,root,,,,)' +'connection con1' +SELECT @@global.character_set_client; +@@global.character_set_client +utf8 +SELECT @@session.character_set_client; +@@session.character_set_client +latin1 +'Bug# 35372: session character_set_client is not effected by global character_set_client' +'#--------------------FN_DYNVARS_010_02-------------------------#' +'connection default' +SHOW VARIABLES like 'character_set_client'; +Variable_name Value +character_set_client latin1 +DROP TABLE IF EXISTS t1; +CREATE TABLE t1(a CHAR(3) character set utf8); +'---verifying character_set_client with a utf8 character----' +'For latin1 characterset'; +SET @@session.character_set_client = latin1; +INSERT INTO t1 values('è'); +SELECT a,CHAR_LENGTH(a) FROM t1; +a CHAR_LENGTH(a) +è 2 +DELETE FROM t1; +'For utf8 characterset'; +SET @@session.character_set_client = utf8; +INSERT INTO t1 values('è'); +SELECT a,CHAR_LENGTH(a) FROM t1; +a CHAR_LENGTH(a) + 1 +DELETE FROM t1; +DROP TABLE IF EXISTS t1; +SET @@global.character_set_client = @global_character_set_client; +SET @@session.character_set_client = @session_character_set_client; |