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