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 'global.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 = gb18030; 154SELECT @@session.character_set_connection; 155@@session.character_set_connection 156gb18030 157SET @@session.character_set_connection = latin5; 158SELECT @@session.character_set_connection; 159@@session.character_set_connection 160latin5 161SET @@session.character_set_connection = armscii8; 162SELECT @@session.character_set_connection; 163@@session.character_set_connection 164armscii8 165SET @@session.character_set_connection = utf8; 166SELECT @@session.character_set_connection; 167@@session.character_set_connection 168utf8 169SET @@session.character_set_connection = ucs2; 170SELECT @@session.character_set_connection; 171@@session.character_set_connection 172ucs2 173SET @@session.character_set_connection = cp866; 174SELECT @@session.character_set_connection; 175@@session.character_set_connection 176cp866 177SET @@session.character_set_connection = keybcs2; 178SELECT @@session.character_set_connection; 179@@session.character_set_connection 180keybcs2 181SET @@session.character_set_connection = macce; 182SELECT @@session.character_set_connection; 183@@session.character_set_connection 184macce 185SET @@session.character_set_connection = macroman; 186SELECT @@session.character_set_connection; 187@@session.character_set_connection 188macroman 189SET @@session.character_set_connection = cp852; 190SELECT @@session.character_set_connection; 191@@session.character_set_connection 192cp852 193SET @@session.character_set_connection = latin7; 194SELECT @@session.character_set_connection; 195@@session.character_set_connection 196latin7 197SET @@session.character_set_connection = cp1251; 198SELECT @@session.character_set_connection; 199@@session.character_set_connection 200cp1251 201SET @@session.character_set_connection = cp1256; 202SELECT @@session.character_set_connection; 203@@session.character_set_connection 204cp1256 205SET @@session.character_set_connection = cp1257; 206SELECT @@session.character_set_connection; 207@@session.character_set_connection 208cp1257 209SET @@session.character_set_connection = binary; 210SELECT @@session.character_set_connection; 211@@session.character_set_connection 212binary 213SET @@session.character_set_connection = geostd8; 214SELECT @@session.character_set_connection; 215@@session.character_set_connection 216geostd8 217SET @@session.character_set_connection = cp932; 218SELECT @@session.character_set_connection; 219@@session.character_set_connection 220cp932 221SET @@session.character_set_connection = eucjpms; 222SELECT @@session.character_set_connection; 223@@session.character_set_connection 224eucjpms 225'#--------------------FN_DYNVARS_011_07-------------------------#' 226SET @@global.character_set_connection = big5; 227SELECT @@global.character_set_connection; 228@@global.character_set_connection 229big5 230SET @@global.character_set_connection = dec8; 231SELECT @@global.character_set_connection; 232@@global.character_set_connection 233dec8 234SET @@global.character_set_connection = cp850; 235SELECT @@global.character_set_connection; 236@@global.character_set_connection 237cp850 238SET @@global.character_set_connection = hp8; 239SELECT @@global.character_set_connection; 240@@global.character_set_connection 241hp8 242SET @@global.character_set_connection = koi8r; 243SELECT @@global.character_set_connection; 244@@global.character_set_connection 245koi8r 246SET @@global.character_set_connection = latin1; 247SELECT @@global.character_set_connection; 248@@global.character_set_connection 249latin1 250SET @@global.character_set_connection = latin2; 251SELECT @@global.character_set_connection; 252@@global.character_set_connection 253latin2 254SET @@global.character_set_connection = swe7; 255SELECT @@global.character_set_connection; 256@@global.character_set_connection 257swe7 258SET @@global.character_set_connection = ascii; 259SELECT @@global.character_set_connection; 260@@global.character_set_connection 261ascii 262SET @@global.character_set_connection = ujis; 263SELECT @@global.character_set_connection; 264@@global.character_set_connection 265ujis 266SET @@global.character_set_connection = sjis; 267SELECT @@global.character_set_connection; 268@@global.character_set_connection 269sjis 270SET @@global.character_set_connection = hebrew; 271SELECT @@global.character_set_connection; 272@@global.character_set_connection 273hebrew 274SET @@global.character_set_connection = tis620; 275SELECT @@global.character_set_connection; 276@@global.character_set_connection 277tis620 278SET @@global.character_set_connection = euckr; 279SELECT @@global.character_set_connection; 280@@global.character_set_connection 281euckr 282SET @@global.character_set_connection = koi8u; 283SELECT @@global.character_set_connection; 284@@global.character_set_connection 285koi8u 286SET @@global.character_set_connection = gb2312; 287SELECT @@global.character_set_connection; 288@@global.character_set_connection 289gb2312 290SET @@global.character_set_connection = greek; 291SELECT @@global.character_set_connection; 292@@global.character_set_connection 293greek 294SET @@global.character_set_connection = cp1250; 295SELECT @@global.character_set_connection; 296@@global.character_set_connection 297cp1250 298SET @@global.character_set_connection = gbk; 299SELECT @@global.character_set_connection; 300@@global.character_set_connection 301gbk 302SET @@global.character_set_connection = gb18030; 303SELECT @@global.character_set_connection; 304@@global.character_set_connection 305gb18030 306SET @@global.character_set_connection = latin5; 307SELECT @@global.character_set_connection; 308@@global.character_set_connection 309latin5 310SET @@global.character_set_connection = armscii8; 311SELECT @@global.character_set_connection; 312@@global.character_set_connection 313armscii8 314SET @@global.character_set_connection = utf8; 315SELECT @@global.character_set_connection; 316@@global.character_set_connection 317utf8 318SET @@global.character_set_connection = ucs2; 319SELECT @@global.character_set_connection; 320@@global.character_set_connection 321ucs2 322SET @@global.character_set_connection = cp866; 323SELECT @@global.character_set_connection; 324@@global.character_set_connection 325cp866 326SET @@global.character_set_connection = keybcs2; 327SELECT @@global.character_set_connection; 328@@global.character_set_connection 329keybcs2 330SET @@global.character_set_connection = macce; 331SELECT @@global.character_set_connection; 332@@global.character_set_connection 333macce 334SET @@global.character_set_connection = macroman; 335SELECT @@global.character_set_connection; 336@@global.character_set_connection 337macroman 338SET @@global.character_set_connection = cp852; 339SELECT @@global.character_set_connection; 340@@global.character_set_connection 341cp852 342SET @@global.character_set_connection = latin7; 343SELECT @@global.character_set_connection; 344@@global.character_set_connection 345latin7 346SET @@global.character_set_connection = cp1251; 347SELECT @@global.character_set_connection; 348@@global.character_set_connection 349cp1251 350SET @@global.character_set_connection = cp1256; 351SELECT @@global.character_set_connection; 352@@global.character_set_connection 353cp1256 354SET @@global.character_set_connection = cp1257; 355SELECT @@global.character_set_connection; 356@@global.character_set_connection 357cp1257 358SET @@global.character_set_connection = binary; 359SELECT @@global.character_set_connection; 360@@global.character_set_connection 361binary 362SET @@global.character_set_connection = geostd8; 363SELECT @@global.character_set_connection; 364@@global.character_set_connection 365geostd8 366SET @@global.character_set_connection = cp932; 367SELECT @@global.character_set_connection; 368@@global.character_set_connection 369cp932 370SET @@global.character_set_connection = eucjpms; 371SELECT @@global.character_set_connection; 372@@global.character_set_connection 373eucjpms 374'#--------------------FN_DYNVARS_011_08-------------------------#' 375SET @@character_set_connection = UTF8; 376SELECT @@character_set_connection; 377@@character_set_connection 378utf8 379SET @@character_set_connection = utf8; 380SELECT @@character_set_connection; 381@@character_set_connection 382utf8 383SET @@global.character_set_connection = uTf8; 384SELECT @@global.character_set_connection; 385@@global.character_set_connection 386utf8 387'#--------------------FN_DYNVARS_011_09-------------------------#' 388SET @@character_set_connection = 1; 389SELECT @@character_set_connection; 390@@character_set_connection 391big5 392SET @@character_set_connection = 2; 393SELECT @@character_set_connection; 394@@character_set_connection 395latin2 396SET @@character_set_connection = 3; 397SELECT @@character_set_connection; 398@@character_set_connection 399dec8 400SET @@character_set_connection = 36; 401SELECT @@character_set_connection; 402@@character_set_connection 403cp866 404SET @@character_set_connection = 99; 405SELECT @@character_set_connection; 406@@character_set_connection 407cp1250 408SET @@character_set_connection = 100; 409ERROR 42000: Unknown character set: '100' 410SET @@global.character_set_connection = 1; 411SELECT @@global.character_set_connection; 412@@global.character_set_connection 413big5 414SET @@global.character_set_connection = 2; 415SELECT @@global.character_set_connection; 416@@global.character_set_connection 417latin2 418SET @@global.character_set_connection = 3; 419SELECT @@global.character_set_connection; 420@@global.character_set_connection 421dec8 422SET @@global.character_set_connection = 36; 423SELECT @@global.character_set_connection; 424@@global.character_set_connection 425cp866 426SET @@global.character_set_connection = 99; 427SELECT @@global.character_set_connection; 428@@global.character_set_connection 429cp1250 430SET @@global.character_set_connection = 100; 431ERROR 42000: Unknown character set: '100' 432SET @total_charset = (SELECT count(*) FROM INFORMATION_SCHEMA.CHARACTER_SETS); 433SELECT @total_charset; 434@total_charset 43541 436'#--------------------FN_DYNVARS_011_10-------------------------#' 437SET @@character_set_connection = abc; 438ERROR 42000: Unknown character set: 'abc' 439SET @@character_set_connection = 1utf8; 440ERROR 42000: Unknown character set: '1utf8' 441SET @@character_set_connection = 0; 442ERROR 42000: Unknown character set: '0' 443SET @@character_set_connection = 1.1; 444ERROR 42000: Incorrect argument type to variable 'character_set_connection' 445SET @@character_set_connection = -1; 446ERROR 42000: Unknown character set: '-1' 447SET @@character_set_connection = 'utf8 '; 448ERROR 42000: Unknown character set: 'utf8 ' 449SET @@character_set_connection = 'l�tin2'; 450ERROR 42000: Unknown character set: 'l�tin2' 451SET @@character_set_connection = true; 452SELECT @@character_set_connection AS res_with_true; 453res_with_true 454big5 455SET @@character_set_connection = ON; 456ERROR 42000: Unknown character set: 'ON' 457'#--------------------FN_DYNVARS_011_11-------------------------#' 458SET @@global.character_set_connection = abc; 459ERROR 42000: Unknown character set: 'abc' 460SET @@global.character_set_connection = 1utf8; 461ERROR 42000: Unknown character set: '1utf8' 462SET @@global.character_set_connection = 0; 463ERROR 42000: Unknown character set: '0' 464SET @@global.character_set_connection = 1.1; 465ERROR 42000: Incorrect argument type to variable 'character_set_connection' 466SET @@global.character_set_connection = -1; 467ERROR 42000: Unknown character set: '-1' 468SET @@global.character_set_connection = ''; 469ERROR 42000: Unknown character set: '' 470SET @@global.character_set_connection = 'utf'; 471ERROR 42000: Unknown character set: 'utf' 472SET @@global.character_set_connection = true; 473SET @@global.character_set_connection = ON; 474ERROR 42000: Unknown character set: 'ON' 475'#--------------------FN_DYNVARS_011_12-------------------------#' 476SELECT @@global.character_set_connection = 477(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 478WHERE VARIABLE_NAME='character_set_connection') AS res; 479res 4801 481SET @@global.character_set_connection = 1; 482SELECT @@global.character_set_connection; 483@@global.character_set_connection 484big5 485SELECT @@global.character_set_connection = 486(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 487WHERE VARIABLE_NAME='character_set_connection') AS res; 488res 4891 490'#--------------------FN_DYNVARS_011_13-------------------------#' 491SELECT @@character_set_connection = 492(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES 493WHERE VARIABLE_NAME='character_set_connection') AS res; 494res 4951 496SELECT @@local.character_set_connection = 497(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES 498WHERE VARIABLE_NAME='character_set_connection') AS res; 499res 5001 501SELECT @@session.character_set_connection = 502(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES 503WHERE VARIABLE_NAME='character_set_connection') AS res; 504res 5051 506SET @@global.character_set_connection = @global_start_value; 507SELECT @@global.character_set_connection; 508@@global.character_set_connection 509latin1 510SET @@session.character_set_connection = @session_start_value; 511SELECT @@session.character_set_connection; 512@@session.character_set_connection 513latin1 514