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 '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 = latin5_turkish_ci; 278SELECT @@session.collation_connection; 279@@session.collation_connection 280latin5_turkish_ci 281SET @@session.collation_connection = latin5_bin; 282SELECT @@session.collation_connection; 283@@session.collation_connection 284latin5_bin 285SET @@session.collation_connection = armscii8_general_ci; 286SELECT @@session.collation_connection; 287@@session.collation_connection 288armscii8_general_ci 289SET @@session.collation_connection = armscii8_bin; 290SELECT @@session.collation_connection; 291@@session.collation_connection 292armscii8_bin 293SET @@session.collation_connection = utf8_general_ci; 294SELECT @@session.collation_connection; 295@@session.collation_connection 296utf8_general_ci 297SET @@session.collation_connection = utf8_bin; 298SELECT @@session.collation_connection; 299@@session.collation_connection 300utf8_bin 301SET @@session.collation_connection = utf8_unicode_ci; 302SELECT @@session.collation_connection; 303@@session.collation_connection 304utf8_unicode_ci 305SET @@session.collation_connection = utf8_icelandic_ci; 306SELECT @@session.collation_connection; 307@@session.collation_connection 308utf8_icelandic_ci 309SET @@session.collation_connection = utf8_latvian_ci; 310SELECT @@session.collation_connection; 311@@session.collation_connection 312utf8_latvian_ci 313SET @@session.collation_connection = utf8_romanian_ci; 314SELECT @@session.collation_connection; 315@@session.collation_connection 316utf8_romanian_ci 317SET @@session.collation_connection = utf8_slovenian_ci; 318SELECT @@session.collation_connection; 319@@session.collation_connection 320utf8_slovenian_ci 321SET @@session.collation_connection = utf8_polish_ci; 322SELECT @@session.collation_connection; 323@@session.collation_connection 324utf8_polish_ci 325SET @@session.collation_connection = utf8_estonian_ci; 326SELECT @@session.collation_connection; 327@@session.collation_connection 328utf8_estonian_ci 329SET @@session.collation_connection = utf8_spanish_ci; 330SELECT @@session.collation_connection; 331@@session.collation_connection 332utf8_spanish_ci 333SET @@session.collation_connection = utf8_swedish_ci; 334SELECT @@session.collation_connection; 335@@session.collation_connection 336utf8_swedish_ci 337SET @@session.collation_connection = utf8_turkish_ci; 338SELECT @@session.collation_connection; 339@@session.collation_connection 340utf8_turkish_ci 341SET @@session.collation_connection = utf8_czech_ci; 342SELECT @@session.collation_connection; 343@@session.collation_connection 344utf8_czech_ci 345SET @@session.collation_connection = utf8_danish_ci; 346SELECT @@session.collation_connection; 347@@session.collation_connection 348utf8_danish_ci 349SET @@session.collation_connection = utf8_lithuanian_ci; 350SELECT @@session.collation_connection; 351@@session.collation_connection 352utf8_lithuanian_ci 353SET @@session.collation_connection = utf8_slovak_ci; 354SELECT @@session.collation_connection; 355@@session.collation_connection 356utf8_slovak_ci 357SET @@session.collation_connection = utf8_spanish2_ci; 358SELECT @@session.collation_connection; 359@@session.collation_connection 360utf8_spanish2_ci 361SET @@session.collation_connection = utf8_roman_ci; 362SELECT @@session.collation_connection; 363@@session.collation_connection 364utf8_roman_ci 365SET @@session.collation_connection = utf8_persian_ci; 366SELECT @@session.collation_connection; 367@@session.collation_connection 368utf8_persian_ci 369SET @@session.collation_connection = utf8_esperanto_ci; 370SELECT @@session.collation_connection; 371@@session.collation_connection 372utf8_esperanto_ci 373SET @@session.collation_connection = utf8_hungarian_ci; 374SELECT @@session.collation_connection; 375@@session.collation_connection 376utf8_hungarian_ci 377SET @@session.collation_connection = utf8_unicode_520_ci; 378SELECT @@session.collation_connection; 379@@session.collation_connection 380utf8_unicode_520_ci 381SET @@session.collation_connection = ucs2_general_ci; 382SELECT @@session.collation_connection; 383@@session.collation_connection 384ucs2_general_ci 385SET @@session.collation_connection = ucs2_bin; 386SELECT @@session.collation_connection; 387@@session.collation_connection 388ucs2_bin 389SET @@session.collation_connection = ucs2_unicode_ci; 390SELECT @@session.collation_connection; 391@@session.collation_connection 392ucs2_unicode_ci 393SET @@session.collation_connection = ucs2_icelandic_ci; 394SELECT @@session.collation_connection; 395@@session.collation_connection 396ucs2_icelandic_ci 397SET @@session.collation_connection = ucs2_latvian_ci; 398SELECT @@session.collation_connection; 399@@session.collation_connection 400ucs2_latvian_ci 401SET @@session.collation_connection = ucs2_romanian_ci; 402SELECT @@session.collation_connection; 403@@session.collation_connection 404ucs2_romanian_ci 405SET @@session.collation_connection = ucs2_slovenian_ci; 406SELECT @@session.collation_connection; 407@@session.collation_connection 408ucs2_slovenian_ci 409SET @@session.collation_connection = ucs2_polish_ci; 410SELECT @@session.collation_connection; 411@@session.collation_connection 412ucs2_polish_ci 413SET @@session.collation_connection = ucs2_estonian_ci; 414SELECT @@session.collation_connection; 415@@session.collation_connection 416ucs2_estonian_ci 417SET @@session.collation_connection = ucs2_spanish_ci; 418SELECT @@session.collation_connection; 419@@session.collation_connection 420ucs2_spanish_ci 421SET @@session.collation_connection = ucs2_swedish_ci; 422SELECT @@session.collation_connection; 423@@session.collation_connection 424ucs2_swedish_ci 425SET @@session.collation_connection = ucs2_turkish_ci; 426SELECT @@session.collation_connection; 427@@session.collation_connection 428ucs2_turkish_ci 429SET @@session.collation_connection = ucs2_czech_ci; 430SELECT @@session.collation_connection; 431@@session.collation_connection 432ucs2_czech_ci 433SET @@session.collation_connection = ucs2_danish_ci; 434SELECT @@session.collation_connection; 435@@session.collation_connection 436ucs2_danish_ci 437SET @@session.collation_connection = ucs2_lithuanian_ci; 438SELECT @@session.collation_connection; 439@@session.collation_connection 440ucs2_lithuanian_ci 441SET @@session.collation_connection = ucs2_slovak_ci; 442SELECT @@session.collation_connection; 443@@session.collation_connection 444ucs2_slovak_ci 445SET @@session.collation_connection = ucs2_spanish2_ci; 446SELECT @@session.collation_connection; 447@@session.collation_connection 448ucs2_spanish2_ci 449SET @@session.collation_connection = ucs2_roman_ci; 450SELECT @@session.collation_connection; 451@@session.collation_connection 452ucs2_roman_ci 453SET @@session.collation_connection = ucs2_persian_ci; 454SELECT @@session.collation_connection; 455@@session.collation_connection 456ucs2_persian_ci 457SET @@session.collation_connection = ucs2_esperanto_ci; 458SELECT @@session.collation_connection; 459@@session.collation_connection 460ucs2_esperanto_ci 461SET @@session.collation_connection = ucs2_hungarian_ci; 462SELECT @@session.collation_connection; 463@@session.collation_connection 464ucs2_hungarian_ci 465SET @@session.collation_connection = ucs2_unicode_520_ci; 466SELECT @@session.collation_connection; 467@@session.collation_connection 468ucs2_unicode_520_ci 469SET @@session.collation_connection = cp866_general_ci; 470SELECT @@session.collation_connection; 471@@session.collation_connection 472cp866_general_ci 473SET @@session.collation_connection = cp866_bin; 474SELECT @@session.collation_connection; 475@@session.collation_connection 476cp866_bin 477SET @@session.collation_connection = keybcs2_general_ci; 478SELECT @@session.collation_connection; 479@@session.collation_connection 480keybcs2_general_ci 481SET @@session.collation_connection = keybcs2_bin; 482SELECT @@session.collation_connection; 483@@session.collation_connection 484keybcs2_bin 485SET @@session.collation_connection = macce_general_ci; 486SELECT @@session.collation_connection; 487@@session.collation_connection 488macce_general_ci 489SET @@session.collation_connection = macce_bin; 490SELECT @@session.collation_connection; 491@@session.collation_connection 492macce_bin 493SET @@session.collation_connection = macroman_general_ci; 494SELECT @@session.collation_connection; 495@@session.collation_connection 496macroman_general_ci 497SET @@session.collation_connection = macroman_bin; 498SELECT @@session.collation_connection; 499@@session.collation_connection 500macroman_bin 501SET @@session.collation_connection = cp852_general_ci; 502SELECT @@session.collation_connection; 503@@session.collation_connection 504cp852_general_ci 505SET @@session.collation_connection = cp852_bin; 506SELECT @@session.collation_connection; 507@@session.collation_connection 508cp852_bin 509SET @@session.collation_connection = latin7_estonian_cs; 510SELECT @@session.collation_connection; 511@@session.collation_connection 512latin7_estonian_cs 513SET @@session.collation_connection = latin7_general_ci; 514SELECT @@session.collation_connection; 515@@session.collation_connection 516latin7_general_ci 517SET @@session.collation_connection = latin7_general_cs; 518SELECT @@session.collation_connection; 519@@session.collation_connection 520latin7_general_cs 521SET @@session.collation_connection = latin7_bin; 522SELECT @@session.collation_connection; 523@@session.collation_connection 524latin7_bin 525SET @@session.collation_connection = cp1251_bulgarian_ci; 526SELECT @@session.collation_connection; 527@@session.collation_connection 528cp1251_bulgarian_ci 529SET @@session.collation_connection = cp1251_ukrainian_ci; 530SELECT @@session.collation_connection; 531@@session.collation_connection 532cp1251_ukrainian_ci 533SET @@session.collation_connection = cp1251_bin; 534SELECT @@session.collation_connection; 535@@session.collation_connection 536cp1251_bin 537SET @@session.collation_connection = cp1251_general_ci; 538SELECT @@session.collation_connection; 539@@session.collation_connection 540cp1251_general_ci 541SET @@session.collation_connection = cp1251_general_cs; 542SELECT @@session.collation_connection; 543@@session.collation_connection 544cp1251_general_cs 545SET @@session.collation_connection = cp1256_general_ci; 546SELECT @@session.collation_connection; 547@@session.collation_connection 548cp1256_general_ci 549SET @@session.collation_connection = cp1256_bin; 550SELECT @@session.collation_connection; 551@@session.collation_connection 552cp1256_bin 553SET @@session.collation_connection = cp1257_lithuanian_ci; 554SELECT @@session.collation_connection; 555@@session.collation_connection 556cp1257_lithuanian_ci 557SET @@session.collation_connection = cp1257_bin; 558SELECT @@session.collation_connection; 559@@session.collation_connection 560cp1257_bin 561SET @@session.collation_connection = cp1257_general_ci; 562SELECT @@session.collation_connection; 563@@session.collation_connection 564cp1257_general_ci 565SET @@session.collation_connection = binary; 566SELECT @@session.collation_connection; 567@@session.collation_connection 568binary 569SET @@session.collation_connection = geostd8_general_ci; 570SELECT @@session.collation_connection; 571@@session.collation_connection 572geostd8_general_ci 573SET @@session.collation_connection = geostd8_bin; 574SELECT @@session.collation_connection; 575@@session.collation_connection 576geostd8_bin 577SET @@session.collation_connection = cp932_japanese_ci; 578SELECT @@session.collation_connection; 579@@session.collation_connection 580cp932_japanese_ci 581SET @@session.collation_connection = cp932_bin; 582SELECT @@session.collation_connection; 583@@session.collation_connection 584cp932_bin 585SET @@session.collation_connection = eucjpms_japanese_ci; 586SELECT @@session.collation_connection; 587@@session.collation_connection 588eucjpms_japanese_ci 589SET @@session.collation_connection = eucjpms_bin; 590SELECT @@session.collation_connection; 591@@session.collation_connection 592eucjpms_bin 593'#--------------------FN_DYNVARS_015_07-------------------------#' 594SET @@global.collation_connection = big5_chinese_ci; 595SELECT @@global.collation_connection; 596@@global.collation_connection 597big5_chinese_ci 598SET @@global.collation_connection = big5_bin; 599SELECT @@global.collation_connection; 600@@global.collation_connection 601big5_bin 602SET @@global.collation_connection = dec8_swedish_ci; 603SELECT @@global.collation_connection; 604@@global.collation_connection 605dec8_swedish_ci 606SET @@global.collation_connection = dec8_bin; 607SELECT @@global.collation_connection; 608@@global.collation_connection 609dec8_bin 610SET @@global.collation_connection = cp850_general_ci; 611SELECT @@global.collation_connection; 612@@global.collation_connection 613cp850_general_ci 614SET @@global.collation_connection = cp850_bin; 615SELECT @@global.collation_connection; 616@@global.collation_connection 617cp850_bin 618SET @@global.collation_connection = hp8_english_ci; 619SELECT @@global.collation_connection; 620@@global.collation_connection 621hp8_english_ci 622SET @@global.collation_connection = hp8_bin; 623SELECT @@global.collation_connection; 624@@global.collation_connection 625hp8_bin 626SET @@global.collation_connection = koi8r_general_ci; 627SELECT @@global.collation_connection; 628@@global.collation_connection 629koi8r_general_ci 630SET @@global.collation_connection = koi8r_bin; 631SELECT @@global.collation_connection; 632@@global.collation_connection 633koi8r_bin 634SET @@global.collation_connection = latin1_german1_ci; 635SELECT @@global.collation_connection; 636@@global.collation_connection 637latin1_german1_ci 638SET @@global.collation_connection = latin1_swedish_ci; 639SELECT @@global.collation_connection; 640@@global.collation_connection 641latin1_swedish_ci 642SET @@global.collation_connection = latin1_danish_ci; 643SELECT @@global.collation_connection; 644@@global.collation_connection 645latin1_danish_ci 646SET @@global.collation_connection = latin1_german2_ci; 647SELECT @@global.collation_connection; 648@@global.collation_connection 649latin1_german2_ci 650SET @@global.collation_connection = latin1_bin; 651SELECT @@global.collation_connection; 652@@global.collation_connection 653latin1_bin 654SET @@global.collation_connection = latin1_general_ci; 655SELECT @@global.collation_connection; 656@@global.collation_connection 657latin1_general_ci 658SET @@global.collation_connection = latin1_general_cs; 659SELECT @@global.collation_connection; 660@@global.collation_connection 661latin1_general_cs 662SET @@global.collation_connection = latin1_spanish_ci; 663SELECT @@global.collation_connection; 664@@global.collation_connection 665latin1_spanish_ci 666SET @@global.collation_connection = latin2_czech_cs; 667SELECT @@global.collation_connection; 668@@global.collation_connection 669latin2_czech_cs 670SET @@global.collation_connection = latin2_general_ci; 671SELECT @@global.collation_connection; 672@@global.collation_connection 673latin2_general_ci 674SET @@global.collation_connection = latin2_hungarian_ci; 675SELECT @@global.collation_connection; 676@@global.collation_connection 677latin2_hungarian_ci 678SET @@global.collation_connection = latin2_croatian_ci; 679SELECT @@global.collation_connection; 680@@global.collation_connection 681latin2_croatian_ci 682SET @@global.collation_connection = latin2_bin; 683SELECT @@global.collation_connection; 684@@global.collation_connection 685latin2_bin 686SET @@global.collation_connection = swe7_swedish_ci; 687SELECT @@global.collation_connection; 688@@global.collation_connection 689swe7_swedish_ci 690SET @@global.collation_connection = swe7_bin; 691SELECT @@global.collation_connection; 692@@global.collation_connection 693swe7_bin 694SET @@global.collation_connection = ascii_general_ci; 695SELECT @@global.collation_connection; 696@@global.collation_connection 697ascii_general_ci 698SET @@global.collation_connection = ascii_bin; 699SELECT @@global.collation_connection; 700@@global.collation_connection 701ascii_bin 702SET @@global.collation_connection = ujis_japanese_ci; 703SELECT @@global.collation_connection; 704@@global.collation_connection 705ujis_japanese_ci 706SET @@global.collation_connection = ujis_bin; 707SELECT @@global.collation_connection; 708@@global.collation_connection 709ujis_bin 710SET @@global.collation_connection = sjis_japanese_ci; 711SELECT @@global.collation_connection; 712@@global.collation_connection 713sjis_japanese_ci 714SET @@global.collation_connection = sjis_bin; 715SELECT @@global.collation_connection; 716@@global.collation_connection 717sjis_bin 718SET @@global.collation_connection = hebrew_general_ci; 719SELECT @@global.collation_connection; 720@@global.collation_connection 721hebrew_general_ci 722SET @@global.collation_connection = hebrew_bin; 723SELECT @@global.collation_connection; 724@@global.collation_connection 725hebrew_bin 726SET @@global.collation_connection = tis620_thai_ci; 727SELECT @@global.collation_connection; 728@@global.collation_connection 729tis620_thai_ci 730SET @@global.collation_connection = tis620_bin; 731SELECT @@global.collation_connection; 732@@global.collation_connection 733tis620_bin 734SET @@global.collation_connection = euckr_korean_ci; 735SELECT @@global.collation_connection; 736@@global.collation_connection 737euckr_korean_ci 738SET @@global.collation_connection = euckr_bin; 739SELECT @@global.collation_connection; 740@@global.collation_connection 741euckr_bin 742SET @@global.collation_connection = koi8u_general_ci; 743SELECT @@global.collation_connection; 744@@global.collation_connection 745koi8u_general_ci 746SET @@global.collation_connection = koi8u_bin; 747SELECT @@global.collation_connection; 748@@global.collation_connection 749koi8u_bin 750SET @@global.collation_connection = gb2312_chinese_ci; 751SELECT @@global.collation_connection; 752@@global.collation_connection 753gb2312_chinese_ci 754SET @@global.collation_connection = gb2312_bin; 755SELECT @@global.collation_connection; 756@@global.collation_connection 757gb2312_bin 758SET @@global.collation_connection = greek_general_ci; 759SELECT @@global.collation_connection; 760@@global.collation_connection 761greek_general_ci 762SET @@global.collation_connection = greek_bin; 763SELECT @@global.collation_connection; 764@@global.collation_connection 765greek_bin 766SET @@global.collation_connection = cp1250_general_ci; 767SELECT @@global.collation_connection; 768@@global.collation_connection 769cp1250_general_ci 770SET @@global.collation_connection = cp1250_czech_cs; 771SELECT @@global.collation_connection; 772@@global.collation_connection 773cp1250_czech_cs 774SET @@global.collation_connection = cp1250_croatian_ci; 775SELECT @@global.collation_connection; 776@@global.collation_connection 777cp1250_croatian_ci 778SET @@global.collation_connection = cp1250_bin; 779SELECT @@global.collation_connection; 780@@global.collation_connection 781cp1250_bin 782SET @@global.collation_connection = cp1250_polish_ci; 783SELECT @@global.collation_connection; 784@@global.collation_connection 785cp1250_polish_ci 786SET @@global.collation_connection = gbk_chinese_ci; 787SELECT @@global.collation_connection; 788@@global.collation_connection 789gbk_chinese_ci 790SET @@global.collation_connection = gbk_bin; 791SELECT @@global.collation_connection; 792@@global.collation_connection 793gbk_bin 794SET @@global.collation_connection = latin5_turkish_ci; 795SELECT @@global.collation_connection; 796@@global.collation_connection 797latin5_turkish_ci 798SET @@global.collation_connection = latin5_bin; 799SELECT @@global.collation_connection; 800@@global.collation_connection 801latin5_bin 802SET @@global.collation_connection = armscii8_general_ci; 803SELECT @@global.collation_connection; 804@@global.collation_connection 805armscii8_general_ci 806SET @@global.collation_connection = armscii8_bin; 807SELECT @@global.collation_connection; 808@@global.collation_connection 809armscii8_bin 810SET @@global.collation_connection = utf8_general_ci; 811SELECT @@global.collation_connection; 812@@global.collation_connection 813utf8_general_ci 814SET @@global.collation_connection = utf8_bin; 815SELECT @@global.collation_connection; 816@@global.collation_connection 817utf8_bin 818SET @@global.collation_connection = utf8_unicode_ci; 819SELECT @@global.collation_connection; 820@@global.collation_connection 821utf8_unicode_ci 822SET @@global.collation_connection = utf8_icelandic_ci; 823SELECT @@global.collation_connection; 824@@global.collation_connection 825utf8_icelandic_ci 826SET @@global.collation_connection = utf8_latvian_ci; 827SELECT @@global.collation_connection; 828@@global.collation_connection 829utf8_latvian_ci 830SET @@global.collation_connection = utf8_romanian_ci; 831SELECT @@global.collation_connection; 832@@global.collation_connection 833utf8_romanian_ci 834SET @@global.collation_connection = utf8_slovenian_ci; 835SELECT @@global.collation_connection; 836@@global.collation_connection 837utf8_slovenian_ci 838SET @@global.collation_connection = utf8_polish_ci; 839SELECT @@global.collation_connection; 840@@global.collation_connection 841utf8_polish_ci 842SET @@global.collation_connection = utf8_estonian_ci; 843SELECT @@global.collation_connection; 844@@global.collation_connection 845utf8_estonian_ci 846SET @@global.collation_connection = utf8_spanish_ci; 847SELECT @@global.collation_connection; 848@@global.collation_connection 849utf8_spanish_ci 850SET @@global.collation_connection = utf8_swedish_ci; 851SELECT @@global.collation_connection; 852@@global.collation_connection 853utf8_swedish_ci 854SET @@global.collation_connection = utf8_turkish_ci; 855SELECT @@global.collation_connection; 856@@global.collation_connection 857utf8_turkish_ci 858SET @@global.collation_connection = utf8_czech_ci; 859SELECT @@global.collation_connection; 860@@global.collation_connection 861utf8_czech_ci 862SET @@global.collation_connection = utf8_danish_ci; 863SELECT @@global.collation_connection; 864@@global.collation_connection 865utf8_danish_ci 866SET @@global.collation_connection = utf8_lithuanian_ci; 867SELECT @@global.collation_connection; 868@@global.collation_connection 869utf8_lithuanian_ci 870SET @@global.collation_connection = utf8_slovak_ci; 871SELECT @@global.collation_connection; 872@@global.collation_connection 873utf8_slovak_ci 874SET @@global.collation_connection = utf8_spanish2_ci; 875SELECT @@global.collation_connection; 876@@global.collation_connection 877utf8_spanish2_ci 878SET @@global.collation_connection = utf8_roman_ci; 879SELECT @@global.collation_connection; 880@@global.collation_connection 881utf8_roman_ci 882SET @@global.collation_connection = utf8_persian_ci; 883SELECT @@global.collation_connection; 884@@global.collation_connection 885utf8_persian_ci 886SET @@global.collation_connection = utf8_esperanto_ci; 887SELECT @@global.collation_connection; 888@@global.collation_connection 889utf8_esperanto_ci 890SET @@global.collation_connection = utf8_hungarian_ci; 891SELECT @@global.collation_connection; 892@@global.collation_connection 893utf8_hungarian_ci 894SET @@global.collation_connection = utf8_unicode_520_ci; 895SELECT @@global.collation_connection; 896@@global.collation_connection 897utf8_unicode_520_ci 898SET @@global.collation_connection = ucs2_general_ci; 899SELECT @@global.collation_connection; 900@@global.collation_connection 901ucs2_general_ci 902SET @@global.collation_connection = ucs2_bin; 903SELECT @@global.collation_connection; 904@@global.collation_connection 905ucs2_bin 906SET @@global.collation_connection = ucs2_unicode_ci; 907SELECT @@global.collation_connection; 908@@global.collation_connection 909ucs2_unicode_ci 910SET @@global.collation_connection = ucs2_icelandic_ci; 911SELECT @@global.collation_connection; 912@@global.collation_connection 913ucs2_icelandic_ci 914SET @@global.collation_connection = ucs2_latvian_ci; 915SELECT @@global.collation_connection; 916@@global.collation_connection 917ucs2_latvian_ci 918SET @@global.collation_connection = ucs2_romanian_ci; 919SELECT @@global.collation_connection; 920@@global.collation_connection 921ucs2_romanian_ci 922SET @@global.collation_connection = ucs2_slovenian_ci; 923SELECT @@global.collation_connection; 924@@global.collation_connection 925ucs2_slovenian_ci 926SET @@global.collation_connection = ucs2_polish_ci; 927SELECT @@global.collation_connection; 928@@global.collation_connection 929ucs2_polish_ci 930SET @@global.collation_connection = ucs2_estonian_ci; 931SELECT @@global.collation_connection; 932@@global.collation_connection 933ucs2_estonian_ci 934SET @@global.collation_connection = ucs2_spanish_ci; 935SELECT @@global.collation_connection; 936@@global.collation_connection 937ucs2_spanish_ci 938SET @@global.collation_connection = ucs2_swedish_ci; 939SELECT @@global.collation_connection; 940@@global.collation_connection 941ucs2_swedish_ci 942SET @@global.collation_connection = ucs2_turkish_ci; 943SELECT @@global.collation_connection; 944@@global.collation_connection 945ucs2_turkish_ci 946SET @@global.collation_connection = ucs2_czech_ci; 947SELECT @@global.collation_connection; 948@@global.collation_connection 949ucs2_czech_ci 950SET @@global.collation_connection = ucs2_danish_ci; 951SELECT @@global.collation_connection; 952@@global.collation_connection 953ucs2_danish_ci 954SET @@global.collation_connection = ucs2_lithuanian_ci; 955SELECT @@global.collation_connection; 956@@global.collation_connection 957ucs2_lithuanian_ci 958SET @@global.collation_connection = ucs2_slovak_ci; 959SELECT @@global.collation_connection; 960@@global.collation_connection 961ucs2_slovak_ci 962SET @@global.collation_connection = ucs2_spanish2_ci; 963SELECT @@global.collation_connection; 964@@global.collation_connection 965ucs2_spanish2_ci 966SET @@global.collation_connection = ucs2_roman_ci; 967SELECT @@global.collation_connection; 968@@global.collation_connection 969ucs2_roman_ci 970SET @@global.collation_connection = ucs2_persian_ci; 971SELECT @@global.collation_connection; 972@@global.collation_connection 973ucs2_persian_ci 974SET @@global.collation_connection = ucs2_esperanto_ci; 975SELECT @@global.collation_connection; 976@@global.collation_connection 977ucs2_esperanto_ci 978SET @@global.collation_connection = ucs2_hungarian_ci; 979SELECT @@global.collation_connection; 980@@global.collation_connection 981ucs2_hungarian_ci 982SET @@global.collation_connection = ucs2_unicode_520_ci; 983SELECT @@global.collation_connection; 984@@global.collation_connection 985ucs2_unicode_520_ci 986SET @@global.collation_connection = cp866_general_ci; 987SELECT @@global.collation_connection; 988@@global.collation_connection 989cp866_general_ci 990SET @@global.collation_connection = cp866_bin; 991SELECT @@global.collation_connection; 992@@global.collation_connection 993cp866_bin 994SET @@global.collation_connection = keybcs2_general_ci; 995SELECT @@global.collation_connection; 996@@global.collation_connection 997keybcs2_general_ci 998SET @@global.collation_connection = keybcs2_bin; 999SELECT @@global.collation_connection; 1000@@global.collation_connection 1001keybcs2_bin 1002SET @@global.collation_connection = macce_general_ci; 1003SELECT @@global.collation_connection; 1004@@global.collation_connection 1005macce_general_ci 1006SET @@global.collation_connection = macce_bin; 1007SELECT @@global.collation_connection; 1008@@global.collation_connection 1009macce_bin 1010SET @@global.collation_connection = macroman_general_ci; 1011SELECT @@global.collation_connection; 1012@@global.collation_connection 1013macroman_general_ci 1014SET @@global.collation_connection = macroman_bin; 1015SELECT @@global.collation_connection; 1016@@global.collation_connection 1017macroman_bin 1018SET @@global.collation_connection = cp852_general_ci; 1019SELECT @@global.collation_connection; 1020@@global.collation_connection 1021cp852_general_ci 1022SET @@global.collation_connection = cp852_bin; 1023SELECT @@global.collation_connection; 1024@@global.collation_connection 1025cp852_bin 1026SET @@global.collation_connection = latin7_estonian_cs; 1027SELECT @@global.collation_connection; 1028@@global.collation_connection 1029latin7_estonian_cs 1030SET @@global.collation_connection = latin7_general_ci; 1031SELECT @@global.collation_connection; 1032@@global.collation_connection 1033latin7_general_ci 1034SET @@global.collation_connection = latin7_general_cs; 1035SELECT @@global.collation_connection; 1036@@global.collation_connection 1037latin7_general_cs 1038SET @@global.collation_connection = latin7_bin; 1039SELECT @@global.collation_connection; 1040@@global.collation_connection 1041latin7_bin 1042SET @@global.collation_connection = cp1251_bulgarian_ci; 1043SELECT @@global.collation_connection; 1044@@global.collation_connection 1045cp1251_bulgarian_ci 1046SET @@global.collation_connection = cp1251_ukrainian_ci; 1047SELECT @@global.collation_connection; 1048@@global.collation_connection 1049cp1251_ukrainian_ci 1050SET @@global.collation_connection = cp1251_bin; 1051SELECT @@global.collation_connection; 1052@@global.collation_connection 1053cp1251_bin 1054SET @@global.collation_connection = cp1251_general_ci; 1055SELECT @@global.collation_connection; 1056@@global.collation_connection 1057cp1251_general_ci 1058SET @@global.collation_connection = cp1251_general_cs; 1059SELECT @@global.collation_connection; 1060@@global.collation_connection 1061cp1251_general_cs 1062SET @@global.collation_connection = cp1256_general_ci; 1063SELECT @@global.collation_connection; 1064@@global.collation_connection 1065cp1256_general_ci 1066SET @@global.collation_connection = cp1256_bin; 1067SELECT @@global.collation_connection; 1068@@global.collation_connection 1069cp1256_bin 1070SET @@global.collation_connection = cp1257_lithuanian_ci; 1071SELECT @@global.collation_connection; 1072@@global.collation_connection 1073cp1257_lithuanian_ci 1074SET @@global.collation_connection = cp1257_bin; 1075SELECT @@global.collation_connection; 1076@@global.collation_connection 1077cp1257_bin 1078SET @@global.collation_connection = cp1257_general_ci; 1079SELECT @@global.collation_connection; 1080@@global.collation_connection 1081cp1257_general_ci 1082SET @@global.collation_connection = binary; 1083SELECT @@global.collation_connection; 1084@@global.collation_connection 1085binary 1086SET @@global.collation_connection = geostd8_general_ci; 1087SELECT @@global.collation_connection; 1088@@global.collation_connection 1089geostd8_general_ci 1090SET @@global.collation_connection = geostd8_bin; 1091SELECT @@global.collation_connection; 1092@@global.collation_connection 1093geostd8_bin 1094SET @@global.collation_connection = cp932_japanese_ci; 1095SELECT @@global.collation_connection; 1096@@global.collation_connection 1097cp932_japanese_ci 1098SET @@global.collation_connection = cp932_bin; 1099SELECT @@global.collation_connection; 1100@@global.collation_connection 1101cp932_bin 1102SET @@global.collation_connection = eucjpms_japanese_ci; 1103SELECT @@global.collation_connection; 1104@@global.collation_connection 1105eucjpms_japanese_ci 1106SET @@global.collation_connection = eucjpms_bin; 1107SELECT @@global.collation_connection; 1108@@global.collation_connection 1109eucjpms_bin 1110'#--------------------FN_DYNVARS_015_08-------------------------#' 1111SET @@collation_connection = LATIN7_GENERAL_CS; 1112SELECT @@collation_connection; 1113@@collation_connection 1114latin7_general_cs 1115SET @@collation_connection = latin7_general_cs; 1116SELECT @@collation_connection; 1117@@collation_connection 1118latin7_general_cs 1119SET @@global.collation_connection = Latin7_GeneRal_cS; 1120SELECT @@global.collation_connection; 1121@@global.collation_connection 1122latin7_general_cs 1123'#--------------------FN_DYNVARS_015_09-------------------------#' 1124SET @@collation_connection = 1; 1125SELECT @@collation_connection; 1126@@collation_connection 1127big5_chinese_ci 1128SET @@collation_connection = 2; 1129SELECT @@collation_connection; 1130@@collation_connection 1131latin2_czech_cs 1132SET @@collation_connection = 3; 1133SELECT @@collation_connection; 1134@@collation_connection 1135dec8_swedish_ci 1136SET @@collation_connection = 99; 1137SELECT @@collation_connection; 1138@@collation_connection 1139cp1250_polish_ci 1140SET @@collation_connection = 100; 1141ERROR HY000: Unknown collation: '100' 1142SET @@global.collation_connection = 1; 1143SELECT @@global.collation_connection; 1144@@global.collation_connection 1145big5_chinese_ci 1146SET @@global.collation_connection = 2; 1147SELECT @@global.collation_connection; 1148@@global.collation_connection 1149latin2_czech_cs 1150SET @@global.collation_connection = 3; 1151SELECT @@global.collation_connection; 1152@@global.collation_connection 1153dec8_swedish_ci 1154SET @@global.collation_connection = 99; 1155SELECT @@global.collation_connection; 1156@@global.collation_connection 1157cp1250_polish_ci 1158SET @@global.collation_connection = 100; 1159ERROR HY000: Unknown collation: '100' 1160SET @total_collations = (SELECT count(*) FROM INFORMATION_SCHEMA.COLLATIONS); 1161SELECT @total_collations > 120; 1162@total_collations > 120 11631 1164'#--------------------FN_DYNVARS_015_10-------------------------#' 1165SET @@collation_connection = latin7_binary; 1166ERROR HY000: Unknown collation: 'latin7_binary' 1167SET @@collation_connection = 'eucjpms_japanese_cs'; 1168ERROR HY000: Unknown collation: 'eucjpms_japanese_cs' 1169SET @@collation_connection = 0; 1170ERROR HY000: Unknown collation: '0' 1171SET @@collation_connection = 1.01; 1172ERROR 42000: Incorrect argument type to variable 'collation_connection' 1173SET @@collation_connection = -1; 1174ERROR HY000: Unknown collation: '-1' 1175SET @@collation_connection = ''; 1176ERROR HY000: Unknown collation: '' 1177SET @@collation_connection = ' eucjpms_bin'; 1178ERROR HY000: Unknown collation: ' eucjpms_bin' 1179SET @@collation_connection = true; 1180SELECT @@collation_connection AS res_with_true; 1181res_with_true 1182big5_chinese_ci 1183SET @@collation_connection = ON; 1184ERROR HY000: Unknown collation: 'ON' 1185'#--------------------FN_DYNVARS_015_11-------------------------#' 1186SET @@global.collation_connection = latin7_binary; 1187ERROR HY000: Unknown collation: 'latin7_binary' 1188SET @@global.collation_connection = 'eucjpms_japanese_cs'; 1189ERROR HY000: Unknown collation: 'eucjpms_japanese_cs' 1190SET @@global.collation_connection = 0; 1191ERROR HY000: Unknown collation: '0' 1192SET @@global.collation_connection = 1.1; 1193ERROR 42000: Incorrect argument type to variable 'collation_connection' 1194SET @@global.collation_connection = -1; 1195ERROR HY000: Unknown collation: '-1' 1196SET @@global.collation_connection = ""; 1197ERROR HY000: Unknown collation: '' 1198SET @@global.collation_connection = ' eucjpms_bin'; 1199ERROR HY000: Unknown collation: ' eucjpms_bin' 1200SET @@global.collation_connection = true; 1201SET @@global.collation_connection = ON; 1202ERROR HY000: Unknown collation: 'ON' 1203'#--------------------FN_DYNVARS_015_12-------------------------#' 1204SELECT @@global.collation_connection = 1205(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 1206WHERE VARIABLE_NAME='collation_connection') AS res; 1207res 12081 1209SET @@global.collation_connection = 1; 1210SELECT @@global.collation_connection; 1211@@global.collation_connection 1212big5_chinese_ci 1213SELECT @@global.collation_connection = 1214(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 1215WHERE VARIABLE_NAME='collation_connection') AS res; 1216res 12171 1218'#--------------------FN_DYNVARS_015_13-------------------------#' 1219SELECT @@collation_connection = 1220(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES 1221WHERE VARIABLE_NAME='collation_connection') AS res; 1222res 12231 1224SELECT @@local.collation_connection = 1225(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES 1226WHERE VARIABLE_NAME='collation_connection') AS res; 1227res 12281 1229SELECT @@session.collation_connection = 1230(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES 1231WHERE VARIABLE_NAME='collation_connection') AS res; 1232res 12331 1234SET @@global.collation_connection = @global_start_value; 1235SELECT @@global.collation_connection; 1236@@global.collation_connection 1237latin1_swedish_ci 1238SET @@session.collation_connection = @session_start_value; 1239SELECT @@session.collation_connection; 1240@@session.collation_connection 1241latin1_swedish_ci 1242