1SET @global_start_value = @@global.character_set_connection; 2SELECT @global_start_value; 3@global_start_value 4latin1 5SET @session_start_value = @@character_set_connection; 6SELECT @session_start_value; 7@session_start_value 8latin1 9SET @session_start_value = @@local.character_set_connection; 10SELECT @session_start_value; 11@session_start_value 12latin1 13SET @session_start_value = @@session.character_set_connection; 14SELECT @session_start_value; 15@session_start_value 16latin1 17'#--------------------FN_DYNVARS_011_01------------------#' 18SELECT character_set_connection; 19ERROR 42S22: Unknown column 'character_set_connection' in 'field list' 20SET character_set_connection=utf8; 21SELECT @@session.character_set_connection; 22@@session.character_set_connection 23utf8 24SET global.character_set_connection=utf8; 25ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'character_set_connection=utf8' at line 1 26SET session character_set_connection=utf8; 27SELECT session character_set_connection; 28ERROR 42S22: Unknown column 'session' in 'field list' 29SET global character_set_connection=utf8; 30SELECT global character_set_connection; 31ERROR 42S22: Unknown column 'global' in 'field list' 32'#--------------------FN_DYNVARS_011_02-------------------------#' 33SET @@character_set_connection = latin5; 34SET @@character_set_connection = DEFAULT; 35SELECT @@character_set_connection AS DEFAULT_VALUE; 36DEFAULT_VALUE 37utf8 38SET @@global.character_set_connection = latin5; 39SET @@global.character_set_connection = DEFAULT; 40SELECT @@global.character_set_connection; 41@@global.character_set_connection 42latin1 43'#--------------------FN_DYNVARS_011_03-------------------------#' 44SET @@session.character_set_connection = utf8; 45SELECT @@session.character_set_connection; 46@@session.character_set_connection 47utf8 48SET @@global.character_set_connection = latin2; 49SELECT @@global.character_set_connection; 50@@global.character_set_connection 51latin2 52SELECT @@session.character_set_connection AS res_is_utf8; 53res_is_utf8 54utf8 55SET @@session.character_set_connection = latin5; 56SELECT @@session.character_set_connection; 57@@session.character_set_connection 58latin5 59SELECT @@global.character_set_connection AS res_is_latin2; 60res_is_latin2 61latin2 62SELECT @@global.character_set_connection=@@session.character_set_connection 63AS res_is_false; 64res_is_false 650 66'#--------------------FN_DYNVARS_011_04-------------------------#' 67SELECT @@character_set_connection = @@session.character_set_connection AS res; 68res 691 70SELECT @@character_set_connection = @@local.character_set_connection AS res; 71res 721 73'#--------------------FN_DYNVARS_011_05-------------------------#' 74SET @@character_set_connection = utf8 + latin2; 75ERROR 42S22: Unknown column 'utf8' in 'field list' 76'#--------------------FN_DYNVARS_011_06-------------------------#' 77SET @@session.character_set_connection = big5; 78SELECT @@session.character_set_connection; 79@@session.character_set_connection 80big5 81SET @@session.character_set_connection = dec8; 82SELECT @@session.character_set_connection; 83@@session.character_set_connection 84dec8 85SET @@session.character_set_connection = cp850; 86SELECT @@session.character_set_connection; 87@@session.character_set_connection 88cp850 89SET @@session.character_set_connection = hp8; 90SELECT @@session.character_set_connection; 91@@session.character_set_connection 92hp8 93SET @@session.character_set_connection = koi8r; 94SELECT @@session.character_set_connection; 95@@session.character_set_connection 96koi8r 97SET @@session.character_set_connection = latin1; 98SELECT @@session.character_set_connection; 99@@session.character_set_connection 100latin1 101SET @@session.character_set_connection = latin2; 102SELECT @@session.character_set_connection; 103@@session.character_set_connection 104latin2 105SET @@session.character_set_connection = swe7; 106SELECT @@session.character_set_connection; 107@@session.character_set_connection 108swe7 109SET @@session.character_set_connection = ascii; 110SELECT @@session.character_set_connection; 111@@session.character_set_connection 112ascii 113SET @@session.character_set_connection = ujis; 114SELECT @@session.character_set_connection; 115@@session.character_set_connection 116ujis 117SET @@session.character_set_connection = sjis; 118SELECT @@session.character_set_connection; 119@@session.character_set_connection 120sjis 121SET @@session.character_set_connection = hebrew; 122SELECT @@session.character_set_connection; 123@@session.character_set_connection 124hebrew 125SET @@session.character_set_connection = tis620; 126SELECT @@session.character_set_connection; 127@@session.character_set_connection 128tis620 129SET @@session.character_set_connection = euckr; 130SELECT @@session.character_set_connection; 131@@session.character_set_connection 132euckr 133SET @@session.character_set_connection = koi8u; 134SELECT @@session.character_set_connection; 135@@session.character_set_connection 136koi8u 137SET @@session.character_set_connection = gb2312; 138SELECT @@session.character_set_connection; 139@@session.character_set_connection 140gb2312 141SET @@session.character_set_connection = greek; 142SELECT @@session.character_set_connection; 143@@session.character_set_connection 144greek 145SET @@session.character_set_connection = cp1250; 146SELECT @@session.character_set_connection; 147@@session.character_set_connection 148cp1250 149SET @@session.character_set_connection = gbk; 150SELECT @@session.character_set_connection; 151@@session.character_set_connection 152gbk 153SET @@session.character_set_connection = latin5; 154SELECT @@session.character_set_connection; 155@@session.character_set_connection 156latin5 157SET @@session.character_set_connection = armscii8; 158SELECT @@session.character_set_connection; 159@@session.character_set_connection 160armscii8 161SET @@session.character_set_connection = utf8; 162SELECT @@session.character_set_connection; 163@@session.character_set_connection 164utf8 165SET @@session.character_set_connection = ucs2; 166SELECT @@session.character_set_connection; 167@@session.character_set_connection 168ucs2 169SET @@session.character_set_connection = cp866; 170SELECT @@session.character_set_connection; 171@@session.character_set_connection 172cp866 173SET @@session.character_set_connection = keybcs2; 174SELECT @@session.character_set_connection; 175@@session.character_set_connection 176keybcs2 177SET @@session.character_set_connection = macce; 178SELECT @@session.character_set_connection; 179@@session.character_set_connection 180macce 181SET @@session.character_set_connection = macroman; 182SELECT @@session.character_set_connection; 183@@session.character_set_connection 184macroman 185SET @@session.character_set_connection = cp852; 186SELECT @@session.character_set_connection; 187@@session.character_set_connection 188cp852 189SET @@session.character_set_connection = latin7; 190SELECT @@session.character_set_connection; 191@@session.character_set_connection 192latin7 193SET @@session.character_set_connection = cp1251; 194SELECT @@session.character_set_connection; 195@@session.character_set_connection 196cp1251 197SET @@session.character_set_connection = cp1256; 198SELECT @@session.character_set_connection; 199@@session.character_set_connection 200cp1256 201SET @@session.character_set_connection = cp1257; 202SELECT @@session.character_set_connection; 203@@session.character_set_connection 204cp1257 205SET @@session.character_set_connection = binary; 206SELECT @@session.character_set_connection; 207@@session.character_set_connection 208binary 209SET @@session.character_set_connection = geostd8; 210SELECT @@session.character_set_connection; 211@@session.character_set_connection 212geostd8 213SET @@session.character_set_connection = cp932; 214SELECT @@session.character_set_connection; 215@@session.character_set_connection 216cp932 217SET @@session.character_set_connection = eucjpms; 218SELECT @@session.character_set_connection; 219@@session.character_set_connection 220eucjpms 221'#--------------------FN_DYNVARS_011_07-------------------------#' 222SET @@global.character_set_connection = big5; 223SELECT @@global.character_set_connection; 224@@global.character_set_connection 225big5 226SET @@global.character_set_connection = dec8; 227SELECT @@global.character_set_connection; 228@@global.character_set_connection 229dec8 230SET @@global.character_set_connection = cp850; 231SELECT @@global.character_set_connection; 232@@global.character_set_connection 233cp850 234SET @@global.character_set_connection = hp8; 235SELECT @@global.character_set_connection; 236@@global.character_set_connection 237hp8 238SET @@global.character_set_connection = koi8r; 239SELECT @@global.character_set_connection; 240@@global.character_set_connection 241koi8r 242SET @@global.character_set_connection = latin1; 243SELECT @@global.character_set_connection; 244@@global.character_set_connection 245latin1 246SET @@global.character_set_connection = latin2; 247SELECT @@global.character_set_connection; 248@@global.character_set_connection 249latin2 250SET @@global.character_set_connection = swe7; 251SELECT @@global.character_set_connection; 252@@global.character_set_connection 253swe7 254SET @@global.character_set_connection = ascii; 255SELECT @@global.character_set_connection; 256@@global.character_set_connection 257ascii 258SET @@global.character_set_connection = ujis; 259SELECT @@global.character_set_connection; 260@@global.character_set_connection 261ujis 262SET @@global.character_set_connection = sjis; 263SELECT @@global.character_set_connection; 264@@global.character_set_connection 265sjis 266SET @@global.character_set_connection = hebrew; 267SELECT @@global.character_set_connection; 268@@global.character_set_connection 269hebrew 270SET @@global.character_set_connection = tis620; 271SELECT @@global.character_set_connection; 272@@global.character_set_connection 273tis620 274SET @@global.character_set_connection = euckr; 275SELECT @@global.character_set_connection; 276@@global.character_set_connection 277euckr 278SET @@global.character_set_connection = koi8u; 279SELECT @@global.character_set_connection; 280@@global.character_set_connection 281koi8u 282SET @@global.character_set_connection = gb2312; 283SELECT @@global.character_set_connection; 284@@global.character_set_connection 285gb2312 286SET @@global.character_set_connection = greek; 287SELECT @@global.character_set_connection; 288@@global.character_set_connection 289greek 290SET @@global.character_set_connection = cp1250; 291SELECT @@global.character_set_connection; 292@@global.character_set_connection 293cp1250 294SET @@global.character_set_connection = gbk; 295SELECT @@global.character_set_connection; 296@@global.character_set_connection 297gbk 298SET @@global.character_set_connection = latin5; 299SELECT @@global.character_set_connection; 300@@global.character_set_connection 301latin5 302SET @@global.character_set_connection = armscii8; 303SELECT @@global.character_set_connection; 304@@global.character_set_connection 305armscii8 306SET @@global.character_set_connection = utf8; 307SELECT @@global.character_set_connection; 308@@global.character_set_connection 309utf8 310SET @@global.character_set_connection = ucs2; 311SELECT @@global.character_set_connection; 312@@global.character_set_connection 313ucs2 314SET @@global.character_set_connection = cp866; 315SELECT @@global.character_set_connection; 316@@global.character_set_connection 317cp866 318SET @@global.character_set_connection = keybcs2; 319SELECT @@global.character_set_connection; 320@@global.character_set_connection 321keybcs2 322SET @@global.character_set_connection = macce; 323SELECT @@global.character_set_connection; 324@@global.character_set_connection 325macce 326SET @@global.character_set_connection = macroman; 327SELECT @@global.character_set_connection; 328@@global.character_set_connection 329macroman 330SET @@global.character_set_connection = cp852; 331SELECT @@global.character_set_connection; 332@@global.character_set_connection 333cp852 334SET @@global.character_set_connection = latin7; 335SELECT @@global.character_set_connection; 336@@global.character_set_connection 337latin7 338SET @@global.character_set_connection = cp1251; 339SELECT @@global.character_set_connection; 340@@global.character_set_connection 341cp1251 342SET @@global.character_set_connection = cp1256; 343SELECT @@global.character_set_connection; 344@@global.character_set_connection 345cp1256 346SET @@global.character_set_connection = cp1257; 347SELECT @@global.character_set_connection; 348@@global.character_set_connection 349cp1257 350SET @@global.character_set_connection = binary; 351SELECT @@global.character_set_connection; 352@@global.character_set_connection 353binary 354SET @@global.character_set_connection = geostd8; 355SELECT @@global.character_set_connection; 356@@global.character_set_connection 357geostd8 358SET @@global.character_set_connection = cp932; 359SELECT @@global.character_set_connection; 360@@global.character_set_connection 361cp932 362SET @@global.character_set_connection = eucjpms; 363SELECT @@global.character_set_connection; 364@@global.character_set_connection 365eucjpms 366'#--------------------FN_DYNVARS_011_08-------------------------#' 367SET @@character_set_connection = UTF8; 368SELECT @@character_set_connection; 369@@character_set_connection 370utf8 371SET @@character_set_connection = utf8; 372SELECT @@character_set_connection; 373@@character_set_connection 374utf8 375SET @@global.character_set_connection = uTf8; 376SELECT @@global.character_set_connection; 377@@global.character_set_connection 378utf8 379'#--------------------FN_DYNVARS_011_09-------------------------#' 380SET @@character_set_connection = 1; 381SELECT @@character_set_connection; 382@@character_set_connection 383big5 384SET @@character_set_connection = 2; 385SELECT @@character_set_connection; 386@@character_set_connection 387latin2 388SET @@character_set_connection = 3; 389SELECT @@character_set_connection; 390@@character_set_connection 391dec8 392SET @@character_set_connection = 36; 393SELECT @@character_set_connection; 394@@character_set_connection 395cp866 396SET @@character_set_connection = 99; 397SELECT @@character_set_connection; 398@@character_set_connection 399cp1250 400SET @@character_set_connection = 100; 401ERROR 42000: Unknown character set: '100' 402SET @@global.character_set_connection = 1; 403SELECT @@global.character_set_connection; 404@@global.character_set_connection 405big5 406SET @@global.character_set_connection = 2; 407SELECT @@global.character_set_connection; 408@@global.character_set_connection 409latin2 410SET @@global.character_set_connection = 3; 411SELECT @@global.character_set_connection; 412@@global.character_set_connection 413dec8 414SET @@global.character_set_connection = 36; 415SELECT @@global.character_set_connection; 416@@global.character_set_connection 417cp866 418SET @@global.character_set_connection = 99; 419SELECT @@global.character_set_connection; 420@@global.character_set_connection 421cp1250 422SET @@global.character_set_connection = 100; 423ERROR 42000: Unknown character set: '100' 424SET @total_charset = (SELECT count(*) FROM INFORMATION_SCHEMA.CHARACTER_SETS); 425SELECT @total_charset; 426@total_charset 42740 428'#--------------------FN_DYNVARS_011_10-------------------------#' 429SET @@character_set_connection = abc; 430ERROR 42000: Unknown character set: 'abc' 431SET @@character_set_connection = 1utf8; 432ERROR 42000: Unknown character set: '1utf8' 433SET @@character_set_connection = 0; 434ERROR 42000: Unknown character set: '0' 435SET @@character_set_connection = 1.1; 436ERROR 42000: Incorrect argument type to variable 'character_set_connection' 437SET @@character_set_connection = -1; 438ERROR 42000: Unknown character set: '-1' 439SET @@character_set_connection = 'utf8 '; 440ERROR 42000: Unknown character set: 'utf8 ' 441SET @@character_set_connection = 'l�tin2'; 442ERROR 42000: Unknown character set: 'l�tin2' 443SET @@character_set_connection = true; 444SELECT @@character_set_connection AS res_with_true; 445res_with_true 446big5 447SET @@character_set_connection = ON; 448ERROR 42000: Unknown character set: 'ON' 449'#--------------------FN_DYNVARS_011_11-------------------------#' 450SET @@global.character_set_connection = abc; 451ERROR 42000: Unknown character set: 'abc' 452SET @@global.character_set_connection = 1utf8; 453ERROR 42000: Unknown character set: '1utf8' 454SET @@global.character_set_connection = 0; 455ERROR 42000: Unknown character set: '0' 456SET @@global.character_set_connection = 1.1; 457ERROR 42000: Incorrect argument type to variable 'character_set_connection' 458SET @@global.character_set_connection = -1; 459ERROR 42000: Unknown character set: '-1' 460SET @@global.character_set_connection = ''; 461ERROR 42000: Unknown character set: '' 462SET @@global.character_set_connection = 'utf'; 463ERROR 42000: Unknown character set: 'utf' 464SET @@global.character_set_connection = true; 465SET @@global.character_set_connection = ON; 466ERROR 42000: Unknown character set: 'ON' 467'#--------------------FN_DYNVARS_011_12-------------------------#' 468SELECT @@global.character_set_connection = 469(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 470WHERE VARIABLE_NAME='character_set_connection') AS res; 471res 4721 473SET @@global.character_set_connection = 1; 474SELECT @@global.character_set_connection; 475@@global.character_set_connection 476big5 477SELECT @@global.character_set_connection = 478(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 479WHERE VARIABLE_NAME='character_set_connection') AS res; 480res 4811 482'#--------------------FN_DYNVARS_011_13-------------------------#' 483SELECT @@character_set_connection = 484(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES 485WHERE VARIABLE_NAME='character_set_connection') AS res; 486res 4871 488SELECT @@local.character_set_connection = 489(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES 490WHERE VARIABLE_NAME='character_set_connection') AS res; 491res 4921 493SELECT @@session.character_set_connection = 494(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES 495WHERE VARIABLE_NAME='character_set_connection') AS res; 496res 4971 498SET @@global.character_set_connection = @global_start_value; 499SELECT @@global.character_set_connection; 500@@global.character_set_connection 501latin1 502SET @@session.character_set_connection = @session_start_value; 503SELECT @@session.character_set_connection; 504@@session.character_set_connection 505latin1 506