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