1SET @global_start_value = @@global.collation_server; 2SET @@global.collation_server= @@collation_server; 3SET @session_start_value = @@collation_server; 4SELECT @session_start_value; 5@session_start_value 6latin1_swedish_ci 7SET @session_start_value = @@local.collation_server; 8SELECT @session_start_value; 9@session_start_value 10latin1_swedish_ci 11SET @session_start_value = @@session.collation_server; 12SELECT @session_start_value; 13@session_start_value 14latin1_swedish_ci 15'#--------------------FN_DYNVARS_014_01------------------#' 16SELECT collation_server; 17ERROR 42S22: Unknown column 'collation_server' in 'field list' 18SET collation_server=utf8_unicode_ci; 19SELECT @@session.collation_server; 20@@session.collation_server 21utf8_unicode_ci 22SET session collation_server=utf8_unicode_ci; 23SELECT session collation_server; 24ERROR 42S22: Unknown column 'session' in 'field list' 25SET global collation_server=utf8_unicode_ci; 26SELECT global collation_server; 27ERROR 42S22: Unknown column 'global' in 'field list' 28'#--------------------FN_DYNVARS_014_02-------------------------#' 29SET @@collation_server = latin1_bin; 30SET @@collation_server = DEFAULT; 31SELECT @@collation_server= @@global.collation_server; 32@@collation_server= @@global.collation_server 331 34SET @@global.collation_server = latin1_bin; 35SET @@global.collation_server = DEFAULT; 36SELECT @@global.collation_server = @global_start_value; 37@@global.collation_server = @global_start_value 381 39'#--------------------FN_DYNVARS_014_03-------------------------#' 40SET @@session.collation_server = utf8_polish_ci; 41SELECT @@session.collation_server; 42@@session.collation_server 43utf8_polish_ci 44SET @@global.collation_server = latin7_general_ci; 45SELECT @@global.collation_server; 46@@global.collation_server 47latin7_general_ci 48SELECT @@session.collation_server AS res_is_utf8_polish_ci; 49res_is_utf8_polish_ci 50utf8_polish_ci 51SET @@session.collation_server = latin7_bin; 52SELECT @@session.collation_server; 53@@session.collation_server 54latin7_bin 55SELECT @@global.collation_server AS res_is_latin7_general_ci; 56res_is_latin7_general_ci 57latin7_general_ci 58SELECT @@global.collation_server=@@session.collation_server AS res_is_false; 59res_is_false 600 61'#--------------------FN_DYNVARS_014_04-------------------------#' 62SELECT @@collation_server = @@session.collation_server AS res; 63res 641 65SELECT @@collation_server = @@local.collation_server AS res; 66res 671 68'#--------------------FN_DYNVARS_014_05-------------------------#' 69SET @@collation_server = latin7_general_ci + latin7_general_cs; 70ERROR 42S22: Unknown column 'latin7_general_ci' in 'field list' 71'#--------------------FN_DYNVARS_014_06-------------------------#' 72SET @@session.collation_server = big5_chinese_ci; 73SELECT @@session.collation_server; 74@@session.collation_server 75big5_chinese_ci 76SET @@session.collation_server = big5_bin; 77SELECT @@session.collation_server; 78@@session.collation_server 79big5_bin 80SET @@session.collation_server = dec8_swedish_ci; 81SELECT @@session.collation_server; 82@@session.collation_server 83dec8_swedish_ci 84SET @@session.collation_server = dec8_bin; 85SELECT @@session.collation_server; 86@@session.collation_server 87dec8_bin 88SET @@session.collation_server = cp850_general_ci; 89SELECT @@session.collation_server; 90@@session.collation_server 91cp850_general_ci 92SET @@session.collation_server = cp850_bin; 93SELECT @@session.collation_server; 94@@session.collation_server 95cp850_bin 96SET @@session.collation_server = hp8_english_ci; 97SELECT @@session.collation_server; 98@@session.collation_server 99hp8_english_ci 100SET @@session.collation_server = hp8_bin; 101SELECT @@session.collation_server; 102@@session.collation_server 103hp8_bin 104SET @@session.collation_server = koi8r_general_ci; 105SELECT @@session.collation_server; 106@@session.collation_server 107koi8r_general_ci 108SET @@session.collation_server = koi8r_bin; 109SELECT @@session.collation_server; 110@@session.collation_server 111koi8r_bin 112SET @@session.collation_server = latin1_german1_ci; 113SELECT @@session.collation_server; 114@@session.collation_server 115latin1_german1_ci 116SET @@session.collation_server = latin1_swedish_ci; 117SELECT @@session.collation_server; 118@@session.collation_server 119latin1_swedish_ci 120SET @@session.collation_server = latin1_danish_ci; 121SELECT @@session.collation_server; 122@@session.collation_server 123latin1_danish_ci 124SET @@session.collation_server = latin1_german2_ci; 125SELECT @@session.collation_server; 126@@session.collation_server 127latin1_german2_ci 128SET @@session.collation_server = latin1_bin; 129SELECT @@session.collation_server; 130@@session.collation_server 131latin1_bin 132SET @@session.collation_server = latin1_general_ci; 133SELECT @@session.collation_server; 134@@session.collation_server 135latin1_general_ci 136SET @@session.collation_server = latin1_general_cs; 137SELECT @@session.collation_server; 138@@session.collation_server 139latin1_general_cs 140SET @@session.collation_server = latin1_spanish_ci; 141SELECT @@session.collation_server; 142@@session.collation_server 143latin1_spanish_ci 144SET @@session.collation_server = latin2_czech_cs; 145SELECT @@session.collation_server; 146@@session.collation_server 147latin2_czech_cs 148SET @@session.collation_server = latin2_general_ci; 149SELECT @@session.collation_server; 150@@session.collation_server 151latin2_general_ci 152SET @@session.collation_server = latin2_hungarian_ci; 153SELECT @@session.collation_server; 154@@session.collation_server 155latin2_hungarian_ci 156SET @@session.collation_server = latin2_croatian_ci; 157SELECT @@session.collation_server; 158@@session.collation_server 159latin2_croatian_ci 160SET @@session.collation_server = latin2_bin; 161SELECT @@session.collation_server; 162@@session.collation_server 163latin2_bin 164SET @@session.collation_server = swe7_swedish_ci; 165SELECT @@session.collation_server; 166@@session.collation_server 167swe7_swedish_ci 168SET @@session.collation_server = swe7_bin; 169SELECT @@session.collation_server; 170@@session.collation_server 171swe7_bin 172SET @@session.collation_server = ascii_general_ci; 173SELECT @@session.collation_server; 174@@session.collation_server 175ascii_general_ci 176SET @@session.collation_server = ascii_bin; 177SELECT @@session.collation_server; 178@@session.collation_server 179ascii_bin 180SET @@session.collation_server = ujis_japanese_ci; 181SELECT @@session.collation_server; 182@@session.collation_server 183ujis_japanese_ci 184SET @@session.collation_server = ujis_bin; 185SELECT @@session.collation_server; 186@@session.collation_server 187ujis_bin 188SET @@session.collation_server = sjis_japanese_ci; 189SELECT @@session.collation_server; 190@@session.collation_server 191sjis_japanese_ci 192SET @@session.collation_server = sjis_bin; 193SELECT @@session.collation_server; 194@@session.collation_server 195sjis_bin 196SET @@session.collation_server = hebrew_general_ci; 197SELECT @@session.collation_server; 198@@session.collation_server 199hebrew_general_ci 200SET @@session.collation_server = hebrew_bin; 201SELECT @@session.collation_server; 202@@session.collation_server 203hebrew_bin 204SET @@session.collation_server = tis620_thai_ci; 205SELECT @@session.collation_server; 206@@session.collation_server 207tis620_thai_ci 208SET @@session.collation_server = tis620_bin; 209SELECT @@session.collation_server; 210@@session.collation_server 211tis620_bin 212SET @@session.collation_server = euckr_korean_ci; 213SELECT @@session.collation_server; 214@@session.collation_server 215euckr_korean_ci 216SET @@session.collation_server = euckr_bin; 217SELECT @@session.collation_server; 218@@session.collation_server 219euckr_bin 220SET @@session.collation_server = koi8u_general_ci; 221SELECT @@session.collation_server; 222@@session.collation_server 223koi8u_general_ci 224SET @@session.collation_server = koi8u_bin; 225SELECT @@session.collation_server; 226@@session.collation_server 227koi8u_bin 228SET @@session.collation_server = gb2312_chinese_ci; 229SELECT @@session.collation_server; 230@@session.collation_server 231gb2312_chinese_ci 232SET @@session.collation_server = gb2312_bin; 233SELECT @@session.collation_server; 234@@session.collation_server 235gb2312_bin 236SET @@session.collation_server = greek_general_ci; 237SELECT @@session.collation_server; 238@@session.collation_server 239greek_general_ci 240SET @@session.collation_server = greek_bin; 241SELECT @@session.collation_server; 242@@session.collation_server 243greek_bin 244SET @@session.collation_server = cp1250_general_ci; 245SELECT @@session.collation_server; 246@@session.collation_server 247cp1250_general_ci 248SET @@session.collation_server = cp1250_czech_cs; 249SELECT @@session.collation_server; 250@@session.collation_server 251cp1250_czech_cs 252SET @@session.collation_server = cp1250_croatian_ci; 253SELECT @@session.collation_server; 254@@session.collation_server 255cp1250_croatian_ci 256SET @@session.collation_server = cp1250_bin; 257SELECT @@session.collation_server; 258@@session.collation_server 259cp1250_bin 260SET @@session.collation_server = cp1250_polish_ci; 261SELECT @@session.collation_server; 262@@session.collation_server 263cp1250_polish_ci 264SET @@session.collation_server = gbk_chinese_ci; 265SELECT @@session.collation_server; 266@@session.collation_server 267gbk_chinese_ci 268SET @@session.collation_server = gbk_bin; 269SELECT @@session.collation_server; 270@@session.collation_server 271gbk_bin 272SET @@session.collation_server = latin5_turkish_ci; 273SELECT @@session.collation_server; 274@@session.collation_server 275latin5_turkish_ci 276SET @@session.collation_server = latin5_bin; 277SELECT @@session.collation_server; 278@@session.collation_server 279latin5_bin 280SET @@session.collation_server = armscii8_general_ci; 281SELECT @@session.collation_server; 282@@session.collation_server 283armscii8_general_ci 284SET @@session.collation_server = armscii8_bin; 285SELECT @@session.collation_server; 286@@session.collation_server 287armscii8_bin 288SET @@session.collation_server = utf8_general_ci; 289SELECT @@session.collation_server; 290@@session.collation_server 291utf8_general_ci 292SET @@session.collation_server = utf8_bin; 293SELECT @@session.collation_server; 294@@session.collation_server 295utf8_bin 296SET @@session.collation_server = utf8_unicode_ci; 297SELECT @@session.collation_server; 298@@session.collation_server 299utf8_unicode_ci 300SET @@session.collation_server = utf8_icelandic_ci; 301SELECT @@session.collation_server; 302@@session.collation_server 303utf8_icelandic_ci 304SET @@session.collation_server = utf8_latvian_ci; 305SELECT @@session.collation_server; 306@@session.collation_server 307utf8_latvian_ci 308SET @@session.collation_server = utf8_romanian_ci; 309SELECT @@session.collation_server; 310@@session.collation_server 311utf8_romanian_ci 312SET @@session.collation_server = utf8_slovenian_ci; 313SELECT @@session.collation_server; 314@@session.collation_server 315utf8_slovenian_ci 316SET @@session.collation_server = utf8_polish_ci; 317SELECT @@session.collation_server; 318@@session.collation_server 319utf8_polish_ci 320SET @@session.collation_server = utf8_estonian_ci; 321SELECT @@session.collation_server; 322@@session.collation_server 323utf8_estonian_ci 324SET @@session.collation_server = utf8_spanish_ci; 325SELECT @@session.collation_server; 326@@session.collation_server 327utf8_spanish_ci 328SET @@session.collation_server = utf8_swedish_ci; 329SELECT @@session.collation_server; 330@@session.collation_server 331utf8_swedish_ci 332SET @@session.collation_server = utf8_turkish_ci; 333SELECT @@session.collation_server; 334@@session.collation_server 335utf8_turkish_ci 336SET @@session.collation_server = utf8_czech_ci; 337SELECT @@session.collation_server; 338@@session.collation_server 339utf8_czech_ci 340SET @@session.collation_server = utf8_danish_ci; 341SELECT @@session.collation_server; 342@@session.collation_server 343utf8_danish_ci 344SET @@session.collation_server = utf8_lithuanian_ci; 345SELECT @@session.collation_server; 346@@session.collation_server 347utf8_lithuanian_ci 348SET @@session.collation_server = utf8_slovak_ci; 349SELECT @@session.collation_server; 350@@session.collation_server 351utf8_slovak_ci 352SET @@session.collation_server = utf8_spanish2_ci; 353SELECT @@session.collation_server; 354@@session.collation_server 355utf8_spanish2_ci 356SET @@session.collation_server = utf8_roman_ci; 357SELECT @@session.collation_server; 358@@session.collation_server 359utf8_roman_ci 360SET @@session.collation_server = utf8_persian_ci; 361SELECT @@session.collation_server; 362@@session.collation_server 363utf8_persian_ci 364SET @@session.collation_server = utf8_esperanto_ci; 365SELECT @@session.collation_server; 366@@session.collation_server 367utf8_esperanto_ci 368SET @@session.collation_server = utf8_hungarian_ci; 369SELECT @@session.collation_server; 370@@session.collation_server 371utf8_hungarian_ci 372SET @@session.collation_server = utf8_thai_520_w2; 373SELECT @@session.collation_server; 374@@session.collation_server 375utf8_thai_520_w2 376SET @@session.collation_server = ucs2_general_ci; 377SELECT @@session.collation_server; 378@@session.collation_server 379ucs2_general_ci 380SET @@session.collation_server = ucs2_bin; 381SELECT @@session.collation_server; 382@@session.collation_server 383ucs2_bin 384SET @@session.collation_server = ucs2_unicode_ci; 385SELECT @@session.collation_server; 386@@session.collation_server 387ucs2_unicode_ci 388SET @@session.collation_server = ucs2_icelandic_ci; 389SELECT @@session.collation_server; 390@@session.collation_server 391ucs2_icelandic_ci 392SET @@session.collation_server = ucs2_latvian_ci; 393SELECT @@session.collation_server; 394@@session.collation_server 395ucs2_latvian_ci 396SET @@session.collation_server = ucs2_romanian_ci; 397SELECT @@session.collation_server; 398@@session.collation_server 399ucs2_romanian_ci 400SET @@session.collation_server = ucs2_slovenian_ci; 401SELECT @@session.collation_server; 402@@session.collation_server 403ucs2_slovenian_ci 404SET @@session.collation_server = ucs2_polish_ci; 405SELECT @@session.collation_server; 406@@session.collation_server 407ucs2_polish_ci 408SET @@session.collation_server = ucs2_estonian_ci; 409SELECT @@session.collation_server; 410@@session.collation_server 411ucs2_estonian_ci 412SET @@session.collation_server = ucs2_spanish_ci; 413SELECT @@session.collation_server; 414@@session.collation_server 415ucs2_spanish_ci 416SET @@session.collation_server = ucs2_swedish_ci; 417SELECT @@session.collation_server; 418@@session.collation_server 419ucs2_swedish_ci 420SET @@session.collation_server = ucs2_turkish_ci; 421SELECT @@session.collation_server; 422@@session.collation_server 423ucs2_turkish_ci 424SET @@session.collation_server = ucs2_czech_ci; 425SELECT @@session.collation_server; 426@@session.collation_server 427ucs2_czech_ci 428SET @@session.collation_server = ucs2_danish_ci; 429SELECT @@session.collation_server; 430@@session.collation_server 431ucs2_danish_ci 432SET @@session.collation_server = ucs2_lithuanian_ci; 433SELECT @@session.collation_server; 434@@session.collation_server 435ucs2_lithuanian_ci 436SET @@session.collation_server = ucs2_slovak_ci; 437SELECT @@session.collation_server; 438@@session.collation_server 439ucs2_slovak_ci 440SET @@session.collation_server = ucs2_spanish2_ci; 441SELECT @@session.collation_server; 442@@session.collation_server 443ucs2_spanish2_ci 444SET @@session.collation_server = ucs2_roman_ci; 445SELECT @@session.collation_server; 446@@session.collation_server 447ucs2_roman_ci 448SET @@session.collation_server = ucs2_persian_ci; 449SELECT @@session.collation_server; 450@@session.collation_server 451ucs2_persian_ci 452SET @@session.collation_server = ucs2_esperanto_ci; 453SELECT @@session.collation_server; 454@@session.collation_server 455ucs2_esperanto_ci 456SET @@session.collation_server = ucs2_hungarian_ci; 457SELECT @@session.collation_server; 458@@session.collation_server 459ucs2_hungarian_ci 460SET @@session.collation_server = cp866_general_ci; 461SELECT @@session.collation_server; 462@@session.collation_server 463cp866_general_ci 464SET @@session.collation_server = cp866_bin; 465SELECT @@session.collation_server; 466@@session.collation_server 467cp866_bin 468SET @@session.collation_server = keybcs2_general_ci; 469SELECT @@session.collation_server; 470@@session.collation_server 471keybcs2_general_ci 472SET @@session.collation_server = keybcs2_bin; 473SELECT @@session.collation_server; 474@@session.collation_server 475keybcs2_bin 476SET @@session.collation_server = macce_general_ci; 477SELECT @@session.collation_server; 478@@session.collation_server 479macce_general_ci 480SET @@session.collation_server = macce_bin; 481SELECT @@session.collation_server; 482@@session.collation_server 483macce_bin 484SET @@session.collation_server = macroman_general_ci; 485SELECT @@session.collation_server; 486@@session.collation_server 487macroman_general_ci 488SET @@session.collation_server = macroman_bin; 489SELECT @@session.collation_server; 490@@session.collation_server 491macroman_bin 492SET @@session.collation_server = cp852_general_ci; 493SELECT @@session.collation_server; 494@@session.collation_server 495cp852_general_ci 496SET @@session.collation_server = cp852_bin; 497SELECT @@session.collation_server; 498@@session.collation_server 499cp852_bin 500SET @@session.collation_server = latin7_estonian_cs; 501SELECT @@session.collation_server; 502@@session.collation_server 503latin7_estonian_cs 504SET @@session.collation_server = latin7_general_ci; 505SELECT @@session.collation_server; 506@@session.collation_server 507latin7_general_ci 508SET @@session.collation_server = latin7_general_cs; 509SELECT @@session.collation_server; 510@@session.collation_server 511latin7_general_cs 512SET @@session.collation_server = latin7_bin; 513SELECT @@session.collation_server; 514@@session.collation_server 515latin7_bin 516SET @@session.collation_server = cp1251_bulgarian_ci; 517SELECT @@session.collation_server; 518@@session.collation_server 519cp1251_bulgarian_ci 520SET @@session.collation_server = cp1251_ukrainian_ci; 521SELECT @@session.collation_server; 522@@session.collation_server 523cp1251_ukrainian_ci 524SET @@session.collation_server = cp1251_bin; 525SELECT @@session.collation_server; 526@@session.collation_server 527cp1251_bin 528SET @@session.collation_server = cp1251_general_ci; 529SELECT @@session.collation_server; 530@@session.collation_server 531cp1251_general_ci 532SET @@session.collation_server = cp1251_general_cs; 533SELECT @@session.collation_server; 534@@session.collation_server 535cp1251_general_cs 536SET @@session.collation_server = cp1256_general_ci; 537SELECT @@session.collation_server; 538@@session.collation_server 539cp1256_general_ci 540SET @@session.collation_server = cp1256_bin; 541SELECT @@session.collation_server; 542@@session.collation_server 543cp1256_bin 544SET @@session.collation_server = cp1257_lithuanian_ci; 545SELECT @@session.collation_server; 546@@session.collation_server 547cp1257_lithuanian_ci 548SET @@session.collation_server = cp1257_bin; 549SELECT @@session.collation_server; 550@@session.collation_server 551cp1257_bin 552SET @@session.collation_server = cp1257_general_ci; 553SELECT @@session.collation_server; 554@@session.collation_server 555cp1257_general_ci 556SET @@session.collation_server = binary; 557SELECT @@session.collation_server; 558@@session.collation_server 559binary 560SET @@session.collation_server = geostd8_general_ci; 561SELECT @@session.collation_server; 562@@session.collation_server 563geostd8_general_ci 564SET @@session.collation_server = geostd8_bin; 565SELECT @@session.collation_server; 566@@session.collation_server 567geostd8_bin 568SET @@session.collation_server = cp932_japanese_ci; 569SELECT @@session.collation_server; 570@@session.collation_server 571cp932_japanese_ci 572SET @@session.collation_server = cp932_bin; 573SELECT @@session.collation_server; 574@@session.collation_server 575cp932_bin 576SET @@session.collation_server = eucjpms_japanese_ci; 577SELECT @@session.collation_server; 578@@session.collation_server 579eucjpms_japanese_ci 580SET @@session.collation_server = eucjpms_bin; 581SELECT @@session.collation_server; 582@@session.collation_server 583eucjpms_bin 584'#--------------------FN_DYNVARS_014_07-------------------------#' 585SET @@global.collation_server = big5_chinese_ci; 586SELECT @@global.collation_server; 587@@global.collation_server 588big5_chinese_ci 589SET @@global.collation_server = big5_bin; 590SELECT @@global.collation_server; 591@@global.collation_server 592big5_bin 593SET @@global.collation_server = dec8_swedish_ci; 594SELECT @@global.collation_server; 595@@global.collation_server 596dec8_swedish_ci 597SET @@global.collation_server = dec8_bin; 598SELECT @@global.collation_server; 599@@global.collation_server 600dec8_bin 601SET @@global.collation_server = cp850_general_ci; 602SELECT @@global.collation_server; 603@@global.collation_server 604cp850_general_ci 605SET @@global.collation_server = cp850_bin; 606SELECT @@global.collation_server; 607@@global.collation_server 608cp850_bin 609SET @@global.collation_server = hp8_english_ci; 610SELECT @@global.collation_server; 611@@global.collation_server 612hp8_english_ci 613SET @@global.collation_server = hp8_bin; 614SELECT @@global.collation_server; 615@@global.collation_server 616hp8_bin 617SET @@global.collation_server = koi8r_general_ci; 618SELECT @@global.collation_server; 619@@global.collation_server 620koi8r_general_ci 621SET @@global.collation_server = koi8r_bin; 622SELECT @@global.collation_server; 623@@global.collation_server 624koi8r_bin 625SET @@global.collation_server = latin1_german1_ci; 626SELECT @@global.collation_server; 627@@global.collation_server 628latin1_german1_ci 629SET @@global.collation_server = latin1_swedish_ci; 630SELECT @@global.collation_server; 631@@global.collation_server 632latin1_swedish_ci 633SET @@global.collation_server = latin1_danish_ci; 634SELECT @@global.collation_server; 635@@global.collation_server 636latin1_danish_ci 637SET @@global.collation_server = latin1_german2_ci; 638SELECT @@global.collation_server; 639@@global.collation_server 640latin1_german2_ci 641SET @@global.collation_server = latin1_bin; 642SELECT @@global.collation_server; 643@@global.collation_server 644latin1_bin 645SET @@global.collation_server = latin1_general_ci; 646SELECT @@global.collation_server; 647@@global.collation_server 648latin1_general_ci 649SET @@global.collation_server = latin1_general_cs; 650SELECT @@global.collation_server; 651@@global.collation_server 652latin1_general_cs 653SET @@global.collation_server = latin1_spanish_ci; 654SELECT @@global.collation_server; 655@@global.collation_server 656latin1_spanish_ci 657SET @@global.collation_server = latin2_czech_cs; 658SELECT @@global.collation_server; 659@@global.collation_server 660latin2_czech_cs 661SET @@global.collation_server = latin2_general_ci; 662SELECT @@global.collation_server; 663@@global.collation_server 664latin2_general_ci 665SET @@global.collation_server = latin2_hungarian_ci; 666SELECT @@global.collation_server; 667@@global.collation_server 668latin2_hungarian_ci 669SET @@global.collation_server = latin2_croatian_ci; 670SELECT @@global.collation_server; 671@@global.collation_server 672latin2_croatian_ci 673SET @@global.collation_server = latin2_bin; 674SELECT @@global.collation_server; 675@@global.collation_server 676latin2_bin 677SET @@global.collation_server = swe7_swedish_ci; 678SELECT @@global.collation_server; 679@@global.collation_server 680swe7_swedish_ci 681SET @@global.collation_server = swe7_bin; 682SELECT @@global.collation_server; 683@@global.collation_server 684swe7_bin 685SET @@global.collation_server = ascii_general_ci; 686SELECT @@global.collation_server; 687@@global.collation_server 688ascii_general_ci 689SET @@global.collation_server = ascii_bin; 690SELECT @@global.collation_server; 691@@global.collation_server 692ascii_bin 693SET @@global.collation_server = ujis_japanese_ci; 694SELECT @@global.collation_server; 695@@global.collation_server 696ujis_japanese_ci 697SET @@global.collation_server = ujis_bin; 698SELECT @@global.collation_server; 699@@global.collation_server 700ujis_bin 701SET @@global.collation_server = sjis_japanese_ci; 702SELECT @@global.collation_server; 703@@global.collation_server 704sjis_japanese_ci 705SET @@global.collation_server = sjis_bin; 706SELECT @@global.collation_server; 707@@global.collation_server 708sjis_bin 709SET @@global.collation_server = hebrew_general_ci; 710SELECT @@global.collation_server; 711@@global.collation_server 712hebrew_general_ci 713SET @@global.collation_server = hebrew_bin; 714SELECT @@global.collation_server; 715@@global.collation_server 716hebrew_bin 717SET @@global.collation_server = tis620_thai_ci; 718SELECT @@global.collation_server; 719@@global.collation_server 720tis620_thai_ci 721SET @@global.collation_server = tis620_bin; 722SELECT @@global.collation_server; 723@@global.collation_server 724tis620_bin 725SET @@global.collation_server = euckr_korean_ci; 726SELECT @@global.collation_server; 727@@global.collation_server 728euckr_korean_ci 729SET @@global.collation_server = euckr_bin; 730SELECT @@global.collation_server; 731@@global.collation_server 732euckr_bin 733SET @@global.collation_server = koi8u_general_ci; 734SELECT @@global.collation_server; 735@@global.collation_server 736koi8u_general_ci 737SET @@global.collation_server = koi8u_bin; 738SELECT @@global.collation_server; 739@@global.collation_server 740koi8u_bin 741SET @@global.collation_server = gb2312_chinese_ci; 742SELECT @@global.collation_server; 743@@global.collation_server 744gb2312_chinese_ci 745SET @@global.collation_server = gb2312_bin; 746SELECT @@global.collation_server; 747@@global.collation_server 748gb2312_bin 749SET @@global.collation_server = greek_general_ci; 750SELECT @@global.collation_server; 751@@global.collation_server 752greek_general_ci 753SET @@global.collation_server = greek_bin; 754SELECT @@global.collation_server; 755@@global.collation_server 756greek_bin 757SET @@global.collation_server = cp1250_general_ci; 758SELECT @@global.collation_server; 759@@global.collation_server 760cp1250_general_ci 761SET @@global.collation_server = cp1250_czech_cs; 762SELECT @@global.collation_server; 763@@global.collation_server 764cp1250_czech_cs 765SET @@global.collation_server = cp1250_croatian_ci; 766SELECT @@global.collation_server; 767@@global.collation_server 768cp1250_croatian_ci 769SET @@global.collation_server = cp1250_bin; 770SELECT @@global.collation_server; 771@@global.collation_server 772cp1250_bin 773SET @@global.collation_server = cp1250_polish_ci; 774SELECT @@global.collation_server; 775@@global.collation_server 776cp1250_polish_ci 777SET @@global.collation_server = gbk_chinese_ci; 778SELECT @@global.collation_server; 779@@global.collation_server 780gbk_chinese_ci 781SET @@global.collation_server = gbk_bin; 782SELECT @@global.collation_server; 783@@global.collation_server 784gbk_bin 785SET @@global.collation_server = latin5_turkish_ci; 786SELECT @@global.collation_server; 787@@global.collation_server 788latin5_turkish_ci 789SET @@global.collation_server = latin5_bin; 790SELECT @@global.collation_server; 791@@global.collation_server 792latin5_bin 793SET @@global.collation_server = armscii8_general_ci; 794SELECT @@global.collation_server; 795@@global.collation_server 796armscii8_general_ci 797SET @@global.collation_server = armscii8_bin; 798SELECT @@global.collation_server; 799@@global.collation_server 800armscii8_bin 801SET @@global.collation_server = utf8_general_ci; 802SELECT @@global.collation_server; 803@@global.collation_server 804utf8_general_ci 805SET @@global.collation_server = utf8_bin; 806SELECT @@global.collation_server; 807@@global.collation_server 808utf8_bin 809SET @@global.collation_server = utf8_unicode_ci; 810SELECT @@global.collation_server; 811@@global.collation_server 812utf8_unicode_ci 813SET @@global.collation_server = utf8_icelandic_ci; 814SELECT @@global.collation_server; 815@@global.collation_server 816utf8_icelandic_ci 817SET @@global.collation_server = utf8_latvian_ci; 818SELECT @@global.collation_server; 819@@global.collation_server 820utf8_latvian_ci 821SET @@global.collation_server = utf8_romanian_ci; 822SELECT @@global.collation_server; 823@@global.collation_server 824utf8_romanian_ci 825SET @@global.collation_server = utf8_slovenian_ci; 826SELECT @@global.collation_server; 827@@global.collation_server 828utf8_slovenian_ci 829SET @@global.collation_server = utf8_polish_ci; 830SELECT @@global.collation_server; 831@@global.collation_server 832utf8_polish_ci 833SET @@global.collation_server = utf8_estonian_ci; 834SELECT @@global.collation_server; 835@@global.collation_server 836utf8_estonian_ci 837SET @@global.collation_server = utf8_spanish_ci; 838SELECT @@global.collation_server; 839@@global.collation_server 840utf8_spanish_ci 841SET @@global.collation_server = utf8_swedish_ci; 842SELECT @@global.collation_server; 843@@global.collation_server 844utf8_swedish_ci 845SET @@global.collation_server = utf8_turkish_ci; 846SELECT @@global.collation_server; 847@@global.collation_server 848utf8_turkish_ci 849SET @@global.collation_server = utf8_czech_ci; 850SELECT @@global.collation_server; 851@@global.collation_server 852utf8_czech_ci 853SET @@global.collation_server = utf8_danish_ci; 854SELECT @@global.collation_server; 855@@global.collation_server 856utf8_danish_ci 857SET @@global.collation_server = utf8_lithuanian_ci; 858SELECT @@global.collation_server; 859@@global.collation_server 860utf8_lithuanian_ci 861SET @@global.collation_server = utf8_slovak_ci; 862SELECT @@global.collation_server; 863@@global.collation_server 864utf8_slovak_ci 865SET @@global.collation_server = utf8_spanish2_ci; 866SELECT @@global.collation_server; 867@@global.collation_server 868utf8_spanish2_ci 869SET @@global.collation_server = utf8_roman_ci; 870SELECT @@global.collation_server; 871@@global.collation_server 872utf8_roman_ci 873SET @@global.collation_server = utf8_persian_ci; 874SELECT @@global.collation_server; 875@@global.collation_server 876utf8_persian_ci 877SET @@global.collation_server = utf8_esperanto_ci; 878SELECT @@global.collation_server; 879@@global.collation_server 880utf8_esperanto_ci 881SET @@global.collation_server = utf8_hungarian_ci; 882SELECT @@global.collation_server; 883@@global.collation_server 884utf8_hungarian_ci 885SET @@global.collation_server = utf8_thai_520_w2; 886SELECT @@global.collation_server; 887@@global.collation_server 888utf8_thai_520_w2 889SET @@global.collation_server = ucs2_general_ci; 890SELECT @@global.collation_server; 891@@global.collation_server 892ucs2_general_ci 893SET @@global.collation_server = ucs2_bin; 894SELECT @@global.collation_server; 895@@global.collation_server 896ucs2_bin 897SET @@global.collation_server = ucs2_unicode_ci; 898SELECT @@global.collation_server; 899@@global.collation_server 900ucs2_unicode_ci 901SET @@global.collation_server = ucs2_icelandic_ci; 902SELECT @@global.collation_server; 903@@global.collation_server 904ucs2_icelandic_ci 905SET @@global.collation_server = ucs2_latvian_ci; 906SELECT @@global.collation_server; 907@@global.collation_server 908ucs2_latvian_ci 909SET @@global.collation_server = ucs2_romanian_ci; 910SELECT @@global.collation_server; 911@@global.collation_server 912ucs2_romanian_ci 913SET @@global.collation_server = ucs2_slovenian_ci; 914SELECT @@global.collation_server; 915@@global.collation_server 916ucs2_slovenian_ci 917SET @@global.collation_server = ucs2_polish_ci; 918SELECT @@global.collation_server; 919@@global.collation_server 920ucs2_polish_ci 921SET @@global.collation_server = ucs2_estonian_ci; 922SELECT @@global.collation_server; 923@@global.collation_server 924ucs2_estonian_ci 925SET @@global.collation_server = ucs2_spanish_ci; 926SELECT @@global.collation_server; 927@@global.collation_server 928ucs2_spanish_ci 929SET @@global.collation_server = ucs2_swedish_ci; 930SELECT @@global.collation_server; 931@@global.collation_server 932ucs2_swedish_ci 933SET @@global.collation_server = ucs2_turkish_ci; 934SELECT @@global.collation_server; 935@@global.collation_server 936ucs2_turkish_ci 937SET @@global.collation_server = ucs2_czech_ci; 938SELECT @@global.collation_server; 939@@global.collation_server 940ucs2_czech_ci 941SET @@global.collation_server = ucs2_danish_ci; 942SELECT @@global.collation_server; 943@@global.collation_server 944ucs2_danish_ci 945SET @@global.collation_server = ucs2_lithuanian_ci; 946SELECT @@global.collation_server; 947@@global.collation_server 948ucs2_lithuanian_ci 949SET @@global.collation_server = ucs2_slovak_ci; 950SELECT @@global.collation_server; 951@@global.collation_server 952ucs2_slovak_ci 953SET @@global.collation_server = ucs2_spanish2_ci; 954SELECT @@global.collation_server; 955@@global.collation_server 956ucs2_spanish2_ci 957SET @@global.collation_server = ucs2_roman_ci; 958SELECT @@global.collation_server; 959@@global.collation_server 960ucs2_roman_ci 961SET @@global.collation_server = ucs2_persian_ci; 962SELECT @@global.collation_server; 963@@global.collation_server 964ucs2_persian_ci 965SET @@global.collation_server = ucs2_esperanto_ci; 966SELECT @@global.collation_server; 967@@global.collation_server 968ucs2_esperanto_ci 969SET @@global.collation_server = ucs2_hungarian_ci; 970SELECT @@global.collation_server; 971@@global.collation_server 972ucs2_hungarian_ci 973SET @@global.collation_server = cp866_general_ci; 974SELECT @@global.collation_server; 975@@global.collation_server 976cp866_general_ci 977SET @@global.collation_server = cp866_bin; 978SELECT @@global.collation_server; 979@@global.collation_server 980cp866_bin 981SET @@global.collation_server = keybcs2_general_ci; 982SELECT @@global.collation_server; 983@@global.collation_server 984keybcs2_general_ci 985SET @@global.collation_server = keybcs2_bin; 986SELECT @@global.collation_server; 987@@global.collation_server 988keybcs2_bin 989SET @@global.collation_server = macce_general_ci; 990SELECT @@global.collation_server; 991@@global.collation_server 992macce_general_ci 993SET @@global.collation_server = macce_bin; 994SELECT @@global.collation_server; 995@@global.collation_server 996macce_bin 997SET @@global.collation_server = macroman_general_ci; 998SELECT @@global.collation_server; 999@@global.collation_server 1000macroman_general_ci 1001SET @@global.collation_server = macroman_bin; 1002SELECT @@global.collation_server; 1003@@global.collation_server 1004macroman_bin 1005SET @@global.collation_server = cp852_general_ci; 1006SELECT @@global.collation_server; 1007@@global.collation_server 1008cp852_general_ci 1009SET @@global.collation_server = cp852_bin; 1010SELECT @@global.collation_server; 1011@@global.collation_server 1012cp852_bin 1013SET @@global.collation_server = latin7_estonian_cs; 1014SELECT @@global.collation_server; 1015@@global.collation_server 1016latin7_estonian_cs 1017SET @@global.collation_server = latin7_general_ci; 1018SELECT @@global.collation_server; 1019@@global.collation_server 1020latin7_general_ci 1021SET @@global.collation_server = latin7_general_cs; 1022SELECT @@global.collation_server; 1023@@global.collation_server 1024latin7_general_cs 1025SET @@global.collation_server = latin7_bin; 1026SELECT @@global.collation_server; 1027@@global.collation_server 1028latin7_bin 1029SET @@global.collation_server = cp1251_bulgarian_ci; 1030SELECT @@global.collation_server; 1031@@global.collation_server 1032cp1251_bulgarian_ci 1033SET @@global.collation_server = cp1251_ukrainian_ci; 1034SELECT @@global.collation_server; 1035@@global.collation_server 1036cp1251_ukrainian_ci 1037SET @@global.collation_server = cp1251_bin; 1038SELECT @@global.collation_server; 1039@@global.collation_server 1040cp1251_bin 1041SET @@global.collation_server = cp1251_general_ci; 1042SELECT @@global.collation_server; 1043@@global.collation_server 1044cp1251_general_ci 1045SET @@global.collation_server = cp1251_general_cs; 1046SELECT @@global.collation_server; 1047@@global.collation_server 1048cp1251_general_cs 1049SET @@global.collation_server = cp1256_general_ci; 1050SELECT @@global.collation_server; 1051@@global.collation_server 1052cp1256_general_ci 1053SET @@global.collation_server = cp1256_bin; 1054SELECT @@global.collation_server; 1055@@global.collation_server 1056cp1256_bin 1057SET @@global.collation_server = cp1257_lithuanian_ci; 1058SELECT @@global.collation_server; 1059@@global.collation_server 1060cp1257_lithuanian_ci 1061SET @@global.collation_server = cp1257_bin; 1062SELECT @@global.collation_server; 1063@@global.collation_server 1064cp1257_bin 1065SET @@global.collation_server = cp1257_general_ci; 1066SELECT @@global.collation_server; 1067@@global.collation_server 1068cp1257_general_ci 1069SET @@global.collation_server = binary; 1070SELECT @@global.collation_server; 1071@@global.collation_server 1072binary 1073SET @@global.collation_server = geostd8_general_ci; 1074SELECT @@global.collation_server; 1075@@global.collation_server 1076geostd8_general_ci 1077SET @@global.collation_server = geostd8_bin; 1078SELECT @@global.collation_server; 1079@@global.collation_server 1080geostd8_bin 1081SET @@global.collation_server = cp932_japanese_ci; 1082SELECT @@global.collation_server; 1083@@global.collation_server 1084cp932_japanese_ci 1085SET @@global.collation_server = cp932_bin; 1086SELECT @@global.collation_server; 1087@@global.collation_server 1088cp932_bin 1089SET @@global.collation_server = eucjpms_japanese_ci; 1090SELECT @@global.collation_server; 1091@@global.collation_server 1092eucjpms_japanese_ci 1093SET @@global.collation_server = eucjpms_bin; 1094SELECT @@global.collation_server; 1095@@global.collation_server 1096eucjpms_bin 1097'#--------------------FN_DYNVARS_014_08-------------------------#' 1098SET @@collation_server = LATIN7_GENERAL_CS; 1099SELECT @@collation_server; 1100@@collation_server 1101latin7_general_cs 1102SET @@collation_server = latin7_general_cs; 1103SELECT @@collation_server; 1104@@collation_server 1105latin7_general_cs 1106SET @@global.collation_server = Latin7_GeneRal_cS; 1107SELECT @@global.collation_server; 1108@@global.collation_server 1109latin7_general_cs 1110'#--------------------FN_DYNVARS_014_09-------------------------#' 1111SET @@collation_server = 1; 1112SELECT @@collation_server; 1113@@collation_server 1114big5_chinese_ci 1115SET @@collation_server = 2; 1116SELECT @@collation_server; 1117@@collation_server 1118latin2_czech_cs 1119SET @@collation_server = 3; 1120SELECT @@collation_server; 1121@@collation_server 1122dec8_swedish_ci 1123SET @@collation_server = 99; 1124SELECT @@collation_server; 1125@@collation_server 1126cp1250_polish_ci 1127SET @@collation_server = 100; 1128ERROR HY000: Unknown collation: '100' 1129SET @@global.collation_server = 1; 1130SELECT @@global.collation_server; 1131@@global.collation_server 1132big5_chinese_ci 1133SET @@global.collation_server = 2; 1134SELECT @@global.collation_server; 1135@@global.collation_server 1136latin2_czech_cs 1137SET @@global.collation_server = 3; 1138SELECT @@global.collation_server; 1139@@global.collation_server 1140dec8_swedish_ci 1141SET @@global.collation_server = 99; 1142SELECT @@global.collation_server; 1143@@global.collation_server 1144cp1250_polish_ci 1145SET @@global.collation_server = 100; 1146ERROR HY000: Unknown collation: '100' 1147SET @total_collations = (SELECT count(*) FROM INFORMATION_SCHEMA.COLLATIONS); 1148SELECT @total_collations > 120; 1149@total_collations > 120 11501 1151'#--------------------FN_DYNVARS_014_10-------------------------#' 1152SET @@collation_server = latin7_binary; 1153ERROR HY000: Unknown collation: 'latin7_binary' 1154SET @@collation_server = 'eucjpms_japanese_cs'; 1155ERROR HY000: Unknown collation: 'eucjpms_japanese_cs' 1156SET @@collation_server = 0; 1157ERROR HY000: Unknown collation: '0' 1158SET @@collation_server = 1.01; 1159ERROR 42000: Incorrect argument type to variable 'collation_server' 1160SET @@collation_server = -1; 1161ERROR HY000: Unknown collation: '-1' 1162SET @@collation_server = ''; 1163ERROR HY000: Unknown collation: '' 1164SET @@collation_server = ' eucjpms_bin'; 1165ERROR HY000: Unknown collation: ' eucjpms_bin' 1166SET @@collation_server = true; 1167SELECT @@collation_server AS res_with_true; 1168res_with_true 1169big5_chinese_ci 1170SET @@collation_server = ON; 1171ERROR HY000: Unknown collation: 'ON' 1172'#--------------------FN_DYNVARS_014_11-------------------------#' 1173SET @@global.collation_server = latin7_binary; 1174ERROR HY000: Unknown collation: 'latin7_binary' 1175SET @@global.collation_server = 'eucjpms_japanese_cs'; 1176ERROR HY000: Unknown collation: 'eucjpms_japanese_cs' 1177SET @@global.collation_server = 0; 1178ERROR HY000: Unknown collation: '0' 1179SET @@global.collation_server = 1.1; 1180ERROR 42000: Incorrect argument type to variable 'collation_server' 1181SET @@global.collation_server = -1; 1182ERROR HY000: Unknown collation: '-1' 1183SET @@global.collation_server = ""; 1184ERROR HY000: Unknown collation: '' 1185SET @@global.collation_server = ' eucjpms_bin'; 1186ERROR HY000: Unknown collation: ' eucjpms_bin' 1187SET @@global.collation_server = true; 1188SET @@global.collation_server = ON; 1189ERROR HY000: Unknown collation: 'ON' 1190'#--------------------FN_DYNVARS_014_12-------------------------#' 1191SELECT @@global.collation_server = 1192(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 1193WHERE VARIABLE_NAME='collation_server') AS res; 1194res 11951 1196SET @@global.collation_server = 1; 1197SELECT @@global.collation_server; 1198@@global.collation_server 1199big5_chinese_ci 1200SELECT @@global.collation_server = 1201(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 1202WHERE VARIABLE_NAME='collation_server') AS res; 1203res 12041 1205'#--------------------FN_DYNVARS_014_13-------------------------#' 1206SELECT @@collation_server = 1207(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES 1208WHERE VARIABLE_NAME='collation_server') AS res; 1209res 12101 1211SELECT @@local.collation_server = 1212(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES 1213WHERE VARIABLE_NAME='collation_server') AS res; 1214res 12151 1216SELECT @@session.collation_server = 1217(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES 1218WHERE VARIABLE_NAME='collation_server') AS res; 1219res 12201 1221SET @@global.collation_server = @global_start_value; 1222SET @@session.collation_server = @session_start_value; 1223