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