diff options
Diffstat (limited to 'mysql-test/r/character_set_results_func.result')
-rw-r--r-- | mysql-test/r/character_set_results_func.result | 64 |
1 files changed, 64 insertions, 0 deletions
diff --git a/mysql-test/r/character_set_results_func.result b/mysql-test/r/character_set_results_func.result new file mode 100644 index 00000000000..d92821fdfa6 --- /dev/null +++ b/mysql-test/r/character_set_results_func.result @@ -0,0 +1,64 @@ +'#--------------------FN_DYNVARS_012_01-------------------------#' +SET @global_character_set_results = @@global.character_set_results; +SET @session_character_set_results = @@session.character_set_results; +SET @@global.character_set_results = utf8; +'connect (con1,localhost,root,,,,)' +'connection con1' +SELECT @@global.character_set_results; +@@global.character_set_results +utf8 +SELECT @@session.character_set_results; +@@session.character_set_results +utf8 +'#--------------------FN_DYNVARS_012_02-------------------------#' +'connection default' +DROP TABLE IF EXISTS t1; +CREATE TABLE t1(b CHAR(40) character set utf8); +SET NAMES utf8; +'----check string literals against different character_set_results---' +check if results are converted to character_set_results +SET @@session.character_set_results = greek; +SELECT 'ЁЂЃЄ' AS utf_text; +utf_text +???? +check effect of character_set_results when introducers are used +SET @@session.character_set_results = latin1; +SELECT _latin1'Mller' AS latin1_text; +latin1_text +Mller +SET @@session.character_set_results = ascii; +SELECT _latin1'Mller' AS latin1_text; +latin1_text +M?ller +check when we dont want any conversion +SET @@session.character_set_results = NULL; +SELECT 'ЁЂЃЄ' AS utf_text; +utf_text +ЁЂЃЄ +'---check results from table against different character_set_results--' +INSERT INTO t1 VALUES(_utf8'ЁЂЃЄ'); +INSERT INTO t1 VALUES('ФХЦЧШ'); +SET @@session.character_set_results = NULL; +SELECT b, CHAR_LENGTH(b) FROM t1; +b CHAR_LENGTH(b) +ЁЂЃЄ 4 +ФХЦЧШ 5 +SET @@session.character_set_results = utf8; +SELECT b, CHAR_LENGTH(b) FROM t1; +b CHAR_LENGTH(b) +ЁЂЃЄ 4 +ФХЦЧШ 5 +SET @@session.character_set_results = koi8r; +SELECT b, CHAR_LENGTH(b) FROM t1; +b CHAR_LENGTH(b) +??? 4 + 5 +SET @@session.character_set_results = cp1250; +SELECT b, CHAR_LENGTH(b) FROM t1; +b CHAR_LENGTH(b) +???? 4 +????? 5 +DROP TABLE t1; +'connection default;' +SET @@global.character_set_results = @global_character_set_results; +SET @@session.character_set_results = @session_character_set_results; |