1SET @global_start_value = @@global.collation_database; 2SELECT @global_start_value; 3@global_start_value 4latin1_swedish_ci 5SET @session_start_value = @@collation_database; 6SELECT @session_start_value; 7@session_start_value 8latin1_swedish_ci 9SET @session_start_value = @@local.collation_database; 10SELECT @session_start_value; 11@session_start_value 12latin1_swedish_ci 13SET @session_start_value = @@session.collation_database; 14SELECT @session_start_value; 15@session_start_value 16latin1_swedish_ci 17'#--------------------FN_DYNVARS_016_01------------------#' 18SELECT collation_database; 19ERROR 42S22: Unknown column 'collation_database' in 'field list' 20SET collation_database=utf8_unicode_ci; 21Warnings: 22Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 23SELECT @@session.collation_database; 24@@session.collation_database 25utf8_unicode_ci 26SET global.collation_database=utf8_unicode_ci; 27ERROR 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_database=utf8_unicode_ci' at line 1 28SET session collation_database=utf8_unicode_ci; 29Warnings: 30Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 31SELECT session collation_database; 32ERROR 42S22: Unknown column 'session' in 'field list' 33SET global collation_database=utf8_unicode_ci; 34Warnings: 35Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 36SELECT global collation_database; 37ERROR 42S22: Unknown column 'global' in 'field list' 38'#--------------------FN_DYNVARS_016_02-------------------------#' 39SET @@collation_database = latin1_bin; 40Warnings: 41Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 42SET @@collation_database = DEFAULT; 43Warnings: 44Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 45SELECT DEFAULT_COLLATION_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME=DATABASE(); 46DEFAULT_COLLATION_NAME 47latin1_swedish_ci 48SELECT @@collation_database AS DEFAULT_VALUE; 49DEFAULT_VALUE 50latin1_swedish_ci 51SET @@global.collation_database = latin1_bin; 52Warnings: 53Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 54SET @@global.collation_database = DEFAULT; 55Warnings: 56Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 57SELECT @@global.collation_database; 58@@global.collation_database 59latin1_swedish_ci 60'#--------------------FN_DYNVARS_016_03-------------------------#' 61SET @@session.collation_database = utf8_polish_ci; 62Warnings: 63Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 64SELECT @@session.collation_database; 65@@session.collation_database 66utf8_polish_ci 67SET @@global.collation_database = latin7_general_ci; 68Warnings: 69Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 70SELECT @@global.collation_database; 71@@global.collation_database 72latin7_general_ci 73SELECT @@session.collation_database AS res_is_utf8_polish_ci; 74res_is_utf8_polish_ci 75utf8_polish_ci 76SET @@session.collation_database = latin7_bin; 77Warnings: 78Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 79SELECT @@session.collation_database; 80@@session.collation_database 81latin7_bin 82SELECT @@global.collation_database AS res_is_latin7_general_ci; 83res_is_latin7_general_ci 84latin7_general_ci 85SELECT @@global.collation_database=@@session.collation_database AS res_is_false; 86res_is_false 870 88'#--------------------FN_DYNVARS_016_04-------------------------#' 89SELECT @@collation_database = @@session.collation_database AS res; 90res 911 92SELECT @@collation_database = @@local.collation_database AS res; 93res 941 95'#--------------------FN_DYNVARS_016_05-------------------------#' 96SET @@collation_database = latin7_general_ci + latin7_general_cs; 97ERROR 42S22: Unknown column 'latin7_general_ci' in 'field list' 98'#--------------------FN_DYNVARS_016_06-------------------------#' 99SET @@session.collation_database = big5_chinese_ci; 100Warnings: 101Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 102SELECT @@session.collation_database; 103@@session.collation_database 104big5_chinese_ci 105SET @@session.collation_database = big5_bin; 106Warnings: 107Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 108SELECT @@session.collation_database; 109@@session.collation_database 110big5_bin 111SET @@session.collation_database = dec8_swedish_ci; 112Warnings: 113Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 114SELECT @@session.collation_database; 115@@session.collation_database 116dec8_swedish_ci 117SET @@session.collation_database = dec8_bin; 118Warnings: 119Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 120SELECT @@session.collation_database; 121@@session.collation_database 122dec8_bin 123SET @@session.collation_database = cp850_general_ci; 124Warnings: 125Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 126SELECT @@session.collation_database; 127@@session.collation_database 128cp850_general_ci 129SET @@session.collation_database = cp850_bin; 130Warnings: 131Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 132SELECT @@session.collation_database; 133@@session.collation_database 134cp850_bin 135SET @@session.collation_database = hp8_english_ci; 136Warnings: 137Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 138SELECT @@session.collation_database; 139@@session.collation_database 140hp8_english_ci 141SET @@session.collation_database = hp8_bin; 142Warnings: 143Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 144SELECT @@session.collation_database; 145@@session.collation_database 146hp8_bin 147SET @@session.collation_database = koi8r_general_ci; 148Warnings: 149Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 150SELECT @@session.collation_database; 151@@session.collation_database 152koi8r_general_ci 153SET @@session.collation_database = koi8r_bin; 154Warnings: 155Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 156SELECT @@session.collation_database; 157@@session.collation_database 158koi8r_bin 159SET @@session.collation_database = latin1_german1_ci; 160Warnings: 161Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 162SELECT @@session.collation_database; 163@@session.collation_database 164latin1_german1_ci 165SET @@session.collation_database = latin1_swedish_ci; 166Warnings: 167Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 168SELECT @@session.collation_database; 169@@session.collation_database 170latin1_swedish_ci 171SET @@session.collation_database = latin1_danish_ci; 172Warnings: 173Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 174SELECT @@session.collation_database; 175@@session.collation_database 176latin1_danish_ci 177SET @@session.collation_database = latin1_german2_ci; 178Warnings: 179Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 180SELECT @@session.collation_database; 181@@session.collation_database 182latin1_german2_ci 183SET @@session.collation_database = latin1_bin; 184Warnings: 185Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 186SELECT @@session.collation_database; 187@@session.collation_database 188latin1_bin 189SET @@session.collation_database = latin1_general_ci; 190Warnings: 191Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 192SELECT @@session.collation_database; 193@@session.collation_database 194latin1_general_ci 195SET @@session.collation_database = latin1_general_cs; 196Warnings: 197Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 198SELECT @@session.collation_database; 199@@session.collation_database 200latin1_general_cs 201SET @@session.collation_database = latin1_spanish_ci; 202Warnings: 203Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 204SELECT @@session.collation_database; 205@@session.collation_database 206latin1_spanish_ci 207SET @@session.collation_database = latin2_czech_cs; 208Warnings: 209Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 210SELECT @@session.collation_database; 211@@session.collation_database 212latin2_czech_cs 213SET @@session.collation_database = latin2_general_ci; 214Warnings: 215Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 216SELECT @@session.collation_database; 217@@session.collation_database 218latin2_general_ci 219SET @@session.collation_database = latin2_hungarian_ci; 220Warnings: 221Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 222SELECT @@session.collation_database; 223@@session.collation_database 224latin2_hungarian_ci 225SET @@session.collation_database = latin2_croatian_ci; 226Warnings: 227Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 228SELECT @@session.collation_database; 229@@session.collation_database 230latin2_croatian_ci 231SET @@session.collation_database = latin2_bin; 232Warnings: 233Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 234SELECT @@session.collation_database; 235@@session.collation_database 236latin2_bin 237SET @@session.collation_database = swe7_swedish_ci; 238Warnings: 239Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 240SELECT @@session.collation_database; 241@@session.collation_database 242swe7_swedish_ci 243SET @@session.collation_database = swe7_bin; 244Warnings: 245Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 246SELECT @@session.collation_database; 247@@session.collation_database 248swe7_bin 249SET @@session.collation_database = ascii_general_ci; 250Warnings: 251Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 252SELECT @@session.collation_database; 253@@session.collation_database 254ascii_general_ci 255SET @@session.collation_database = ascii_bin; 256Warnings: 257Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 258SELECT @@session.collation_database; 259@@session.collation_database 260ascii_bin 261SET @@session.collation_database = ujis_japanese_ci; 262Warnings: 263Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 264SELECT @@session.collation_database; 265@@session.collation_database 266ujis_japanese_ci 267SET @@session.collation_database = ujis_bin; 268Warnings: 269Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 270SELECT @@session.collation_database; 271@@session.collation_database 272ujis_bin 273SET @@session.collation_database = sjis_japanese_ci; 274Warnings: 275Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 276SELECT @@session.collation_database; 277@@session.collation_database 278sjis_japanese_ci 279SET @@session.collation_database = sjis_bin; 280Warnings: 281Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 282SELECT @@session.collation_database; 283@@session.collation_database 284sjis_bin 285SET @@session.collation_database = hebrew_general_ci; 286Warnings: 287Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 288SELECT @@session.collation_database; 289@@session.collation_database 290hebrew_general_ci 291SET @@session.collation_database = hebrew_bin; 292Warnings: 293Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 294SELECT @@session.collation_database; 295@@session.collation_database 296hebrew_bin 297SET @@session.collation_database = tis620_thai_ci; 298Warnings: 299Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 300SELECT @@session.collation_database; 301@@session.collation_database 302tis620_thai_ci 303SET @@session.collation_database = tis620_bin; 304Warnings: 305Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 306SELECT @@session.collation_database; 307@@session.collation_database 308tis620_bin 309SET @@session.collation_database = euckr_korean_ci; 310Warnings: 311Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 312SELECT @@session.collation_database; 313@@session.collation_database 314euckr_korean_ci 315SET @@session.collation_database = euckr_bin; 316Warnings: 317Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 318SELECT @@session.collation_database; 319@@session.collation_database 320euckr_bin 321SET @@session.collation_database = koi8u_general_ci; 322Warnings: 323Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 324SELECT @@session.collation_database; 325@@session.collation_database 326koi8u_general_ci 327SET @@session.collation_database = koi8u_bin; 328Warnings: 329Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 330SELECT @@session.collation_database; 331@@session.collation_database 332koi8u_bin 333SET @@session.collation_database = gb2312_chinese_ci; 334Warnings: 335Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 336SELECT @@session.collation_database; 337@@session.collation_database 338gb2312_chinese_ci 339SET @@session.collation_database = gb2312_bin; 340Warnings: 341Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 342SELECT @@session.collation_database; 343@@session.collation_database 344gb2312_bin 345SET @@session.collation_database = greek_general_ci; 346Warnings: 347Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 348SELECT @@session.collation_database; 349@@session.collation_database 350greek_general_ci 351SET @@session.collation_database = greek_bin; 352Warnings: 353Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 354SELECT @@session.collation_database; 355@@session.collation_database 356greek_bin 357SET @@session.collation_database = cp1250_general_ci; 358Warnings: 359Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 360SELECT @@session.collation_database; 361@@session.collation_database 362cp1250_general_ci 363SET @@session.collation_database = cp1250_czech_cs; 364Warnings: 365Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 366SELECT @@session.collation_database; 367@@session.collation_database 368cp1250_czech_cs 369SET @@session.collation_database = cp1250_croatian_ci; 370Warnings: 371Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 372SELECT @@session.collation_database; 373@@session.collation_database 374cp1250_croatian_ci 375SET @@session.collation_database = cp1250_bin; 376Warnings: 377Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 378SELECT @@session.collation_database; 379@@session.collation_database 380cp1250_bin 381SET @@session.collation_database = cp1250_polish_ci; 382Warnings: 383Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 384SELECT @@session.collation_database; 385@@session.collation_database 386cp1250_polish_ci 387SET @@session.collation_database = gbk_chinese_ci; 388Warnings: 389Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 390SELECT @@session.collation_database; 391@@session.collation_database 392gbk_chinese_ci 393SET @@session.collation_database = gbk_bin; 394Warnings: 395Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 396SELECT @@session.collation_database; 397@@session.collation_database 398gbk_bin 399SET @@session.collation_database = gb18030_chinese_ci; 400Warnings: 401Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 402SELECT @@session.collation_database; 403@@session.collation_database 404gb18030_chinese_ci 405SET @@session.collation_database = gb18030_bin; 406Warnings: 407Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 408SELECT @@session.collation_database; 409@@session.collation_database 410gb18030_bin 411SET @@session.collation_database = latin5_turkish_ci; 412Warnings: 413Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 414SELECT @@session.collation_database; 415@@session.collation_database 416latin5_turkish_ci 417SET @@session.collation_database = latin5_bin; 418Warnings: 419Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 420SELECT @@session.collation_database; 421@@session.collation_database 422latin5_bin 423SET @@session.collation_database = armscii8_general_ci; 424Warnings: 425Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 426SELECT @@session.collation_database; 427@@session.collation_database 428armscii8_general_ci 429SET @@session.collation_database = armscii8_bin; 430Warnings: 431Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 432SELECT @@session.collation_database; 433@@session.collation_database 434armscii8_bin 435SET @@session.collation_database = utf8_general_ci; 436Warnings: 437Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 438SELECT @@session.collation_database; 439@@session.collation_database 440utf8_general_ci 441SET @@session.collation_database = utf8_bin; 442Warnings: 443Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 444SELECT @@session.collation_database; 445@@session.collation_database 446utf8_bin 447SET @@session.collation_database = utf8_unicode_ci; 448Warnings: 449Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 450SELECT @@session.collation_database; 451@@session.collation_database 452utf8_unicode_ci 453SET @@session.collation_database = utf8_icelandic_ci; 454Warnings: 455Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 456SELECT @@session.collation_database; 457@@session.collation_database 458utf8_icelandic_ci 459SET @@session.collation_database = utf8_latvian_ci; 460Warnings: 461Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 462SELECT @@session.collation_database; 463@@session.collation_database 464utf8_latvian_ci 465SET @@session.collation_database = utf8_romanian_ci; 466Warnings: 467Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 468SELECT @@session.collation_database; 469@@session.collation_database 470utf8_romanian_ci 471SET @@session.collation_database = utf8_slovenian_ci; 472Warnings: 473Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 474SELECT @@session.collation_database; 475@@session.collation_database 476utf8_slovenian_ci 477SET @@session.collation_database = utf8_polish_ci; 478Warnings: 479Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 480SELECT @@session.collation_database; 481@@session.collation_database 482utf8_polish_ci 483SET @@session.collation_database = utf8_estonian_ci; 484Warnings: 485Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 486SELECT @@session.collation_database; 487@@session.collation_database 488utf8_estonian_ci 489SET @@session.collation_database = utf8_spanish_ci; 490Warnings: 491Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 492SELECT @@session.collation_database; 493@@session.collation_database 494utf8_spanish_ci 495SET @@session.collation_database = utf8_swedish_ci; 496Warnings: 497Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 498SELECT @@session.collation_database; 499@@session.collation_database 500utf8_swedish_ci 501SET @@session.collation_database = utf8_turkish_ci; 502Warnings: 503Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 504SELECT @@session.collation_database; 505@@session.collation_database 506utf8_turkish_ci 507SET @@session.collation_database = utf8_czech_ci; 508Warnings: 509Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 510SELECT @@session.collation_database; 511@@session.collation_database 512utf8_czech_ci 513SET @@session.collation_database = utf8_danish_ci; 514Warnings: 515Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 516SELECT @@session.collation_database; 517@@session.collation_database 518utf8_danish_ci 519SET @@session.collation_database = utf8_lithuanian_ci; 520Warnings: 521Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 522SELECT @@session.collation_database; 523@@session.collation_database 524utf8_lithuanian_ci 525SET @@session.collation_database = utf8_slovak_ci; 526Warnings: 527Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 528SELECT @@session.collation_database; 529@@session.collation_database 530utf8_slovak_ci 531SET @@session.collation_database = utf8_spanish2_ci; 532Warnings: 533Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 534SELECT @@session.collation_database; 535@@session.collation_database 536utf8_spanish2_ci 537SET @@session.collation_database = utf8_roman_ci; 538Warnings: 539Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 540SELECT @@session.collation_database; 541@@session.collation_database 542utf8_roman_ci 543SET @@session.collation_database = utf8_persian_ci; 544Warnings: 545Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 546SELECT @@session.collation_database; 547@@session.collation_database 548utf8_persian_ci 549SET @@session.collation_database = utf8_esperanto_ci; 550Warnings: 551Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 552SELECT @@session.collation_database; 553@@session.collation_database 554utf8_esperanto_ci 555SET @@session.collation_database = utf8_hungarian_ci; 556Warnings: 557Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 558SELECT @@session.collation_database; 559@@session.collation_database 560utf8_hungarian_ci 561SET @@session.collation_database = utf8_unicode_520_ci; 562Warnings: 563Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 564SELECT @@session.collation_database; 565@@session.collation_database 566utf8_unicode_520_ci 567SET @@session.collation_database = ucs2_general_ci; 568Warnings: 569Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 570SELECT @@session.collation_database; 571@@session.collation_database 572ucs2_general_ci 573SET @@session.collation_database = ucs2_bin; 574Warnings: 575Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 576SELECT @@session.collation_database; 577@@session.collation_database 578ucs2_bin 579SET @@session.collation_database = ucs2_unicode_ci; 580Warnings: 581Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 582SELECT @@session.collation_database; 583@@session.collation_database 584ucs2_unicode_ci 585SET @@session.collation_database = ucs2_icelandic_ci; 586Warnings: 587Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 588SELECT @@session.collation_database; 589@@session.collation_database 590ucs2_icelandic_ci 591SET @@session.collation_database = ucs2_latvian_ci; 592Warnings: 593Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 594SELECT @@session.collation_database; 595@@session.collation_database 596ucs2_latvian_ci 597SET @@session.collation_database = ucs2_romanian_ci; 598Warnings: 599Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 600SELECT @@session.collation_database; 601@@session.collation_database 602ucs2_romanian_ci 603SET @@session.collation_database = ucs2_slovenian_ci; 604Warnings: 605Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 606SELECT @@session.collation_database; 607@@session.collation_database 608ucs2_slovenian_ci 609SET @@session.collation_database = ucs2_polish_ci; 610Warnings: 611Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 612SELECT @@session.collation_database; 613@@session.collation_database 614ucs2_polish_ci 615SET @@session.collation_database = ucs2_estonian_ci; 616Warnings: 617Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 618SELECT @@session.collation_database; 619@@session.collation_database 620ucs2_estonian_ci 621SET @@session.collation_database = ucs2_spanish_ci; 622Warnings: 623Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 624SELECT @@session.collation_database; 625@@session.collation_database 626ucs2_spanish_ci 627SET @@session.collation_database = ucs2_swedish_ci; 628Warnings: 629Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 630SELECT @@session.collation_database; 631@@session.collation_database 632ucs2_swedish_ci 633SET @@session.collation_database = ucs2_turkish_ci; 634Warnings: 635Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 636SELECT @@session.collation_database; 637@@session.collation_database 638ucs2_turkish_ci 639SET @@session.collation_database = ucs2_czech_ci; 640Warnings: 641Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 642SELECT @@session.collation_database; 643@@session.collation_database 644ucs2_czech_ci 645SET @@session.collation_database = ucs2_danish_ci; 646Warnings: 647Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 648SELECT @@session.collation_database; 649@@session.collation_database 650ucs2_danish_ci 651SET @@session.collation_database = ucs2_lithuanian_ci; 652Warnings: 653Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 654SELECT @@session.collation_database; 655@@session.collation_database 656ucs2_lithuanian_ci 657SET @@session.collation_database = ucs2_slovak_ci; 658Warnings: 659Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 660SELECT @@session.collation_database; 661@@session.collation_database 662ucs2_slovak_ci 663SET @@session.collation_database = ucs2_spanish2_ci; 664Warnings: 665Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 666SELECT @@session.collation_database; 667@@session.collation_database 668ucs2_spanish2_ci 669SET @@session.collation_database = ucs2_roman_ci; 670Warnings: 671Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 672SELECT @@session.collation_database; 673@@session.collation_database 674ucs2_roman_ci 675SET @@session.collation_database = ucs2_persian_ci; 676Warnings: 677Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 678SELECT @@session.collation_database; 679@@session.collation_database 680ucs2_persian_ci 681SET @@session.collation_database = ucs2_esperanto_ci; 682Warnings: 683Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 684SELECT @@session.collation_database; 685@@session.collation_database 686ucs2_esperanto_ci 687SET @@session.collation_database = ucs2_hungarian_ci; 688Warnings: 689Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 690SELECT @@session.collation_database; 691@@session.collation_database 692ucs2_hungarian_ci 693SET @@session.collation_database = ucs2_unicode_520_ci; 694Warnings: 695Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 696SELECT @@session.collation_database; 697@@session.collation_database 698ucs2_unicode_520_ci 699SET @@session.collation_database = cp866_general_ci; 700Warnings: 701Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 702SELECT @@session.collation_database; 703@@session.collation_database 704cp866_general_ci 705SET @@session.collation_database = cp866_bin; 706Warnings: 707Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 708SELECT @@session.collation_database; 709@@session.collation_database 710cp866_bin 711SET @@session.collation_database = keybcs2_general_ci; 712Warnings: 713Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 714SELECT @@session.collation_database; 715@@session.collation_database 716keybcs2_general_ci 717SET @@session.collation_database = keybcs2_bin; 718Warnings: 719Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 720SELECT @@session.collation_database; 721@@session.collation_database 722keybcs2_bin 723SET @@session.collation_database = macce_general_ci; 724Warnings: 725Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 726SELECT @@session.collation_database; 727@@session.collation_database 728macce_general_ci 729SET @@session.collation_database = macce_bin; 730Warnings: 731Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 732SELECT @@session.collation_database; 733@@session.collation_database 734macce_bin 735SET @@session.collation_database = macroman_general_ci; 736Warnings: 737Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 738SELECT @@session.collation_database; 739@@session.collation_database 740macroman_general_ci 741SET @@session.collation_database = macroman_bin; 742Warnings: 743Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 744SELECT @@session.collation_database; 745@@session.collation_database 746macroman_bin 747SET @@session.collation_database = cp852_general_ci; 748Warnings: 749Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 750SELECT @@session.collation_database; 751@@session.collation_database 752cp852_general_ci 753SET @@session.collation_database = cp852_bin; 754Warnings: 755Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 756SELECT @@session.collation_database; 757@@session.collation_database 758cp852_bin 759SET @@session.collation_database = latin7_estonian_cs; 760Warnings: 761Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 762SELECT @@session.collation_database; 763@@session.collation_database 764latin7_estonian_cs 765SET @@session.collation_database = latin7_general_ci; 766Warnings: 767Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 768SELECT @@session.collation_database; 769@@session.collation_database 770latin7_general_ci 771SET @@session.collation_database = latin7_general_cs; 772Warnings: 773Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 774SELECT @@session.collation_database; 775@@session.collation_database 776latin7_general_cs 777SET @@session.collation_database = latin7_bin; 778Warnings: 779Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 780SELECT @@session.collation_database; 781@@session.collation_database 782latin7_bin 783SET @@session.collation_database = cp1251_bulgarian_ci; 784Warnings: 785Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 786SELECT @@session.collation_database; 787@@session.collation_database 788cp1251_bulgarian_ci 789SET @@session.collation_database = cp1251_ukrainian_ci; 790Warnings: 791Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 792SELECT @@session.collation_database; 793@@session.collation_database 794cp1251_ukrainian_ci 795SET @@session.collation_database = cp1251_bin; 796Warnings: 797Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 798SELECT @@session.collation_database; 799@@session.collation_database 800cp1251_bin 801SET @@session.collation_database = cp1251_general_ci; 802Warnings: 803Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 804SELECT @@session.collation_database; 805@@session.collation_database 806cp1251_general_ci 807SET @@session.collation_database = cp1251_general_cs; 808Warnings: 809Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 810SELECT @@session.collation_database; 811@@session.collation_database 812cp1251_general_cs 813SET @@session.collation_database = cp1256_general_ci; 814Warnings: 815Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 816SELECT @@session.collation_database; 817@@session.collation_database 818cp1256_general_ci 819SET @@session.collation_database = cp1256_bin; 820Warnings: 821Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 822SELECT @@session.collation_database; 823@@session.collation_database 824cp1256_bin 825SET @@session.collation_database = cp1257_lithuanian_ci; 826Warnings: 827Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 828SELECT @@session.collation_database; 829@@session.collation_database 830cp1257_lithuanian_ci 831SET @@session.collation_database = cp1257_bin; 832Warnings: 833Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 834SELECT @@session.collation_database; 835@@session.collation_database 836cp1257_bin 837SET @@session.collation_database = cp1257_general_ci; 838Warnings: 839Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 840SELECT @@session.collation_database; 841@@session.collation_database 842cp1257_general_ci 843SET @@session.collation_database = binary; 844Warnings: 845Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 846SELECT @@session.collation_database; 847@@session.collation_database 848binary 849SET @@session.collation_database = geostd8_general_ci; 850Warnings: 851Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 852SELECT @@session.collation_database; 853@@session.collation_database 854geostd8_general_ci 855SET @@session.collation_database = geostd8_bin; 856Warnings: 857Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 858SELECT @@session.collation_database; 859@@session.collation_database 860geostd8_bin 861SET @@session.collation_database = cp932_japanese_ci; 862Warnings: 863Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 864SELECT @@session.collation_database; 865@@session.collation_database 866cp932_japanese_ci 867SET @@session.collation_database = cp932_bin; 868Warnings: 869Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 870SELECT @@session.collation_database; 871@@session.collation_database 872cp932_bin 873SET @@session.collation_database = eucjpms_japanese_ci; 874Warnings: 875Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 876SELECT @@session.collation_database; 877@@session.collation_database 878eucjpms_japanese_ci 879SET @@session.collation_database = eucjpms_bin; 880Warnings: 881Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 882SELECT @@session.collation_database; 883@@session.collation_database 884eucjpms_bin 885'#--------------------FN_DYNVARS_016_07-------------------------#' 886SET @@global.collation_database = big5_chinese_ci; 887Warnings: 888Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 889SELECT @@global.collation_database; 890@@global.collation_database 891big5_chinese_ci 892SET @@global.collation_database = big5_bin; 893Warnings: 894Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 895SELECT @@global.collation_database; 896@@global.collation_database 897big5_bin 898SET @@global.collation_database = dec8_swedish_ci; 899Warnings: 900Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 901SELECT @@global.collation_database; 902@@global.collation_database 903dec8_swedish_ci 904SET @@global.collation_database = dec8_bin; 905Warnings: 906Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 907SELECT @@global.collation_database; 908@@global.collation_database 909dec8_bin 910SET @@global.collation_database = cp850_general_ci; 911Warnings: 912Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 913SELECT @@global.collation_database; 914@@global.collation_database 915cp850_general_ci 916SET @@global.collation_database = cp850_bin; 917Warnings: 918Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 919SELECT @@global.collation_database; 920@@global.collation_database 921cp850_bin 922SET @@global.collation_database = hp8_english_ci; 923Warnings: 924Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 925SELECT @@global.collation_database; 926@@global.collation_database 927hp8_english_ci 928SET @@global.collation_database = hp8_bin; 929Warnings: 930Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 931SELECT @@global.collation_database; 932@@global.collation_database 933hp8_bin 934SET @@global.collation_database = koi8r_general_ci; 935Warnings: 936Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 937SELECT @@global.collation_database; 938@@global.collation_database 939koi8r_general_ci 940SET @@global.collation_database = koi8r_bin; 941Warnings: 942Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 943SELECT @@global.collation_database; 944@@global.collation_database 945koi8r_bin 946SET @@global.collation_database = latin1_german1_ci; 947Warnings: 948Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 949SELECT @@global.collation_database; 950@@global.collation_database 951latin1_german1_ci 952SET @@global.collation_database = latin1_swedish_ci; 953Warnings: 954Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 955SELECT @@global.collation_database; 956@@global.collation_database 957latin1_swedish_ci 958SET @@global.collation_database = latin1_danish_ci; 959Warnings: 960Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 961SELECT @@global.collation_database; 962@@global.collation_database 963latin1_danish_ci 964SET @@global.collation_database = latin1_german2_ci; 965Warnings: 966Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 967SELECT @@global.collation_database; 968@@global.collation_database 969latin1_german2_ci 970SET @@global.collation_database = latin1_bin; 971Warnings: 972Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 973SELECT @@global.collation_database; 974@@global.collation_database 975latin1_bin 976SET @@global.collation_database = latin1_general_ci; 977Warnings: 978Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 979SELECT @@global.collation_database; 980@@global.collation_database 981latin1_general_ci 982SET @@global.collation_database = latin1_general_cs; 983Warnings: 984Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 985SELECT @@global.collation_database; 986@@global.collation_database 987latin1_general_cs 988SET @@global.collation_database = latin1_spanish_ci; 989Warnings: 990Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 991SELECT @@global.collation_database; 992@@global.collation_database 993latin1_spanish_ci 994SET @@global.collation_database = latin2_czech_cs; 995Warnings: 996Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 997SELECT @@global.collation_database; 998@@global.collation_database 999latin2_czech_cs 1000SET @@global.collation_database = latin2_general_ci; 1001Warnings: 1002Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1003SELECT @@global.collation_database; 1004@@global.collation_database 1005latin2_general_ci 1006SET @@global.collation_database = latin2_hungarian_ci; 1007Warnings: 1008Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1009SELECT @@global.collation_database; 1010@@global.collation_database 1011latin2_hungarian_ci 1012SET @@global.collation_database = latin2_croatian_ci; 1013Warnings: 1014Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1015SELECT @@global.collation_database; 1016@@global.collation_database 1017latin2_croatian_ci 1018SET @@global.collation_database = latin2_bin; 1019Warnings: 1020Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1021SELECT @@global.collation_database; 1022@@global.collation_database 1023latin2_bin 1024SET @@global.collation_database = swe7_swedish_ci; 1025Warnings: 1026Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1027SELECT @@global.collation_database; 1028@@global.collation_database 1029swe7_swedish_ci 1030SET @@global.collation_database = swe7_bin; 1031Warnings: 1032Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1033SELECT @@global.collation_database; 1034@@global.collation_database 1035swe7_bin 1036SET @@global.collation_database = ascii_general_ci; 1037Warnings: 1038Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1039SELECT @@global.collation_database; 1040@@global.collation_database 1041ascii_general_ci 1042SET @@global.collation_database = ascii_bin; 1043Warnings: 1044Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1045SELECT @@global.collation_database; 1046@@global.collation_database 1047ascii_bin 1048SET @@global.collation_database = ujis_japanese_ci; 1049Warnings: 1050Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1051SELECT @@global.collation_database; 1052@@global.collation_database 1053ujis_japanese_ci 1054SET @@global.collation_database = ujis_bin; 1055Warnings: 1056Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1057SELECT @@global.collation_database; 1058@@global.collation_database 1059ujis_bin 1060SET @@global.collation_database = sjis_japanese_ci; 1061Warnings: 1062Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1063SELECT @@global.collation_database; 1064@@global.collation_database 1065sjis_japanese_ci 1066SET @@global.collation_database = sjis_bin; 1067Warnings: 1068Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1069SELECT @@global.collation_database; 1070@@global.collation_database 1071sjis_bin 1072SET @@global.collation_database = hebrew_general_ci; 1073Warnings: 1074Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1075SELECT @@global.collation_database; 1076@@global.collation_database 1077hebrew_general_ci 1078SET @@global.collation_database = hebrew_bin; 1079Warnings: 1080Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1081SELECT @@global.collation_database; 1082@@global.collation_database 1083hebrew_bin 1084SET @@global.collation_database = tis620_thai_ci; 1085Warnings: 1086Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1087SELECT @@global.collation_database; 1088@@global.collation_database 1089tis620_thai_ci 1090SET @@global.collation_database = tis620_bin; 1091Warnings: 1092Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1093SELECT @@global.collation_database; 1094@@global.collation_database 1095tis620_bin 1096SET @@global.collation_database = euckr_korean_ci; 1097Warnings: 1098Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1099SELECT @@global.collation_database; 1100@@global.collation_database 1101euckr_korean_ci 1102SET @@global.collation_database = euckr_bin; 1103Warnings: 1104Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1105SELECT @@global.collation_database; 1106@@global.collation_database 1107euckr_bin 1108SET @@global.collation_database = koi8u_general_ci; 1109Warnings: 1110Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1111SELECT @@global.collation_database; 1112@@global.collation_database 1113koi8u_general_ci 1114SET @@global.collation_database = koi8u_bin; 1115Warnings: 1116Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1117SELECT @@global.collation_database; 1118@@global.collation_database 1119koi8u_bin 1120SET @@global.collation_database = gb2312_chinese_ci; 1121Warnings: 1122Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1123SELECT @@global.collation_database; 1124@@global.collation_database 1125gb2312_chinese_ci 1126SET @@global.collation_database = gb2312_bin; 1127Warnings: 1128Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1129SELECT @@global.collation_database; 1130@@global.collation_database 1131gb2312_bin 1132SET @@global.collation_database = greek_general_ci; 1133Warnings: 1134Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1135SELECT @@global.collation_database; 1136@@global.collation_database 1137greek_general_ci 1138SET @@global.collation_database = greek_bin; 1139Warnings: 1140Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1141SELECT @@global.collation_database; 1142@@global.collation_database 1143greek_bin 1144SET @@global.collation_database = cp1250_general_ci; 1145Warnings: 1146Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1147SELECT @@global.collation_database; 1148@@global.collation_database 1149cp1250_general_ci 1150SET @@global.collation_database = cp1250_czech_cs; 1151Warnings: 1152Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1153SELECT @@global.collation_database; 1154@@global.collation_database 1155cp1250_czech_cs 1156SET @@global.collation_database = cp1250_croatian_ci; 1157Warnings: 1158Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1159SELECT @@global.collation_database; 1160@@global.collation_database 1161cp1250_croatian_ci 1162SET @@global.collation_database = cp1250_bin; 1163Warnings: 1164Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1165SELECT @@global.collation_database; 1166@@global.collation_database 1167cp1250_bin 1168SET @@global.collation_database = cp1250_polish_ci; 1169Warnings: 1170Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1171SELECT @@global.collation_database; 1172@@global.collation_database 1173cp1250_polish_ci 1174SET @@global.collation_database = gbk_chinese_ci; 1175Warnings: 1176Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1177SELECT @@global.collation_database; 1178@@global.collation_database 1179gbk_chinese_ci 1180SET @@global.collation_database = gbk_bin; 1181Warnings: 1182Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1183SELECT @@global.collation_database; 1184@@global.collation_database 1185gbk_bin 1186SET @@global.collation_database = gb18030_chinese_ci; 1187Warnings: 1188Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1189SELECT @@global.collation_database; 1190@@global.collation_database 1191gb18030_chinese_ci 1192SET @@global.collation_database = gb18030_bin; 1193Warnings: 1194Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1195SELECT @@global.collation_database; 1196@@global.collation_database 1197gb18030_bin 1198SET @@global.collation_database = latin5_turkish_ci; 1199Warnings: 1200Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1201SELECT @@global.collation_database; 1202@@global.collation_database 1203latin5_turkish_ci 1204SET @@global.collation_database = latin5_bin; 1205Warnings: 1206Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1207SELECT @@global.collation_database; 1208@@global.collation_database 1209latin5_bin 1210SET @@global.collation_database = armscii8_general_ci; 1211Warnings: 1212Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1213SELECT @@global.collation_database; 1214@@global.collation_database 1215armscii8_general_ci 1216SET @@global.collation_database = armscii8_bin; 1217Warnings: 1218Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1219SELECT @@global.collation_database; 1220@@global.collation_database 1221armscii8_bin 1222SET @@global.collation_database = utf8_general_ci; 1223Warnings: 1224Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1225SELECT @@global.collation_database; 1226@@global.collation_database 1227utf8_general_ci 1228SET @@global.collation_database = utf8_bin; 1229Warnings: 1230Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1231SELECT @@global.collation_database; 1232@@global.collation_database 1233utf8_bin 1234SET @@global.collation_database = utf8_unicode_ci; 1235Warnings: 1236Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1237SELECT @@global.collation_database; 1238@@global.collation_database 1239utf8_unicode_ci 1240SET @@global.collation_database = utf8_icelandic_ci; 1241Warnings: 1242Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1243SELECT @@global.collation_database; 1244@@global.collation_database 1245utf8_icelandic_ci 1246SET @@global.collation_database = utf8_latvian_ci; 1247Warnings: 1248Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1249SELECT @@global.collation_database; 1250@@global.collation_database 1251utf8_latvian_ci 1252SET @@global.collation_database = utf8_romanian_ci; 1253Warnings: 1254Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1255SELECT @@global.collation_database; 1256@@global.collation_database 1257utf8_romanian_ci 1258SET @@global.collation_database = utf8_slovenian_ci; 1259Warnings: 1260Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1261SELECT @@global.collation_database; 1262@@global.collation_database 1263utf8_slovenian_ci 1264SET @@global.collation_database = utf8_polish_ci; 1265Warnings: 1266Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1267SELECT @@global.collation_database; 1268@@global.collation_database 1269utf8_polish_ci 1270SET @@global.collation_database = utf8_estonian_ci; 1271Warnings: 1272Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1273SELECT @@global.collation_database; 1274@@global.collation_database 1275utf8_estonian_ci 1276SET @@global.collation_database = utf8_spanish_ci; 1277Warnings: 1278Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1279SELECT @@global.collation_database; 1280@@global.collation_database 1281utf8_spanish_ci 1282SET @@global.collation_database = utf8_swedish_ci; 1283Warnings: 1284Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1285SELECT @@global.collation_database; 1286@@global.collation_database 1287utf8_swedish_ci 1288SET @@global.collation_database = utf8_turkish_ci; 1289Warnings: 1290Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1291SELECT @@global.collation_database; 1292@@global.collation_database 1293utf8_turkish_ci 1294SET @@global.collation_database = utf8_czech_ci; 1295Warnings: 1296Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1297SELECT @@global.collation_database; 1298@@global.collation_database 1299utf8_czech_ci 1300SET @@global.collation_database = utf8_danish_ci; 1301Warnings: 1302Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1303SELECT @@global.collation_database; 1304@@global.collation_database 1305utf8_danish_ci 1306SET @@global.collation_database = utf8_lithuanian_ci; 1307Warnings: 1308Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1309SELECT @@global.collation_database; 1310@@global.collation_database 1311utf8_lithuanian_ci 1312SET @@global.collation_database = utf8_slovak_ci; 1313Warnings: 1314Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1315SELECT @@global.collation_database; 1316@@global.collation_database 1317utf8_slovak_ci 1318SET @@global.collation_database = utf8_spanish2_ci; 1319Warnings: 1320Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1321SELECT @@global.collation_database; 1322@@global.collation_database 1323utf8_spanish2_ci 1324SET @@global.collation_database = utf8_roman_ci; 1325Warnings: 1326Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1327SELECT @@global.collation_database; 1328@@global.collation_database 1329utf8_roman_ci 1330SET @@global.collation_database = utf8_persian_ci; 1331Warnings: 1332Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1333SELECT @@global.collation_database; 1334@@global.collation_database 1335utf8_persian_ci 1336SET @@global.collation_database = utf8_esperanto_ci; 1337Warnings: 1338Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1339SELECT @@global.collation_database; 1340@@global.collation_database 1341utf8_esperanto_ci 1342SET @@global.collation_database = utf8_hungarian_ci; 1343Warnings: 1344Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1345SELECT @@global.collation_database; 1346@@global.collation_database 1347utf8_hungarian_ci 1348SET @@global.collation_database = utf8_unicode_520_ci; 1349Warnings: 1350Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1351SELECT @@global.collation_database; 1352@@global.collation_database 1353utf8_unicode_520_ci 1354SET @@global.collation_database = ucs2_general_ci; 1355Warnings: 1356Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1357SELECT @@global.collation_database; 1358@@global.collation_database 1359ucs2_general_ci 1360SET @@global.collation_database = ucs2_bin; 1361Warnings: 1362Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1363SELECT @@global.collation_database; 1364@@global.collation_database 1365ucs2_bin 1366SET @@global.collation_database = ucs2_unicode_ci; 1367Warnings: 1368Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1369SELECT @@global.collation_database; 1370@@global.collation_database 1371ucs2_unicode_ci 1372SET @@global.collation_database = ucs2_icelandic_ci; 1373Warnings: 1374Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1375SELECT @@global.collation_database; 1376@@global.collation_database 1377ucs2_icelandic_ci 1378SET @@global.collation_database = ucs2_latvian_ci; 1379Warnings: 1380Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1381SELECT @@global.collation_database; 1382@@global.collation_database 1383ucs2_latvian_ci 1384SET @@global.collation_database = ucs2_romanian_ci; 1385Warnings: 1386Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1387SELECT @@global.collation_database; 1388@@global.collation_database 1389ucs2_romanian_ci 1390SET @@global.collation_database = ucs2_slovenian_ci; 1391Warnings: 1392Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1393SELECT @@global.collation_database; 1394@@global.collation_database 1395ucs2_slovenian_ci 1396SET @@global.collation_database = ucs2_polish_ci; 1397Warnings: 1398Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1399SELECT @@global.collation_database; 1400@@global.collation_database 1401ucs2_polish_ci 1402SET @@global.collation_database = ucs2_estonian_ci; 1403Warnings: 1404Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1405SELECT @@global.collation_database; 1406@@global.collation_database 1407ucs2_estonian_ci 1408SET @@global.collation_database = ucs2_spanish_ci; 1409Warnings: 1410Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1411SELECT @@global.collation_database; 1412@@global.collation_database 1413ucs2_spanish_ci 1414SET @@global.collation_database = ucs2_swedish_ci; 1415Warnings: 1416Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1417SELECT @@global.collation_database; 1418@@global.collation_database 1419ucs2_swedish_ci 1420SET @@global.collation_database = ucs2_turkish_ci; 1421Warnings: 1422Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1423SELECT @@global.collation_database; 1424@@global.collation_database 1425ucs2_turkish_ci 1426SET @@global.collation_database = ucs2_czech_ci; 1427Warnings: 1428Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1429SELECT @@global.collation_database; 1430@@global.collation_database 1431ucs2_czech_ci 1432SET @@global.collation_database = ucs2_danish_ci; 1433Warnings: 1434Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1435SELECT @@global.collation_database; 1436@@global.collation_database 1437ucs2_danish_ci 1438SET @@global.collation_database = ucs2_lithuanian_ci; 1439Warnings: 1440Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1441SELECT @@global.collation_database; 1442@@global.collation_database 1443ucs2_lithuanian_ci 1444SET @@global.collation_database = ucs2_slovak_ci; 1445Warnings: 1446Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1447SELECT @@global.collation_database; 1448@@global.collation_database 1449ucs2_slovak_ci 1450SET @@global.collation_database = ucs2_spanish2_ci; 1451Warnings: 1452Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1453SELECT @@global.collation_database; 1454@@global.collation_database 1455ucs2_spanish2_ci 1456SET @@global.collation_database = ucs2_roman_ci; 1457Warnings: 1458Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1459SELECT @@global.collation_database; 1460@@global.collation_database 1461ucs2_roman_ci 1462SET @@global.collation_database = ucs2_persian_ci; 1463Warnings: 1464Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1465SELECT @@global.collation_database; 1466@@global.collation_database 1467ucs2_persian_ci 1468SET @@global.collation_database = ucs2_esperanto_ci; 1469Warnings: 1470Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1471SELECT @@global.collation_database; 1472@@global.collation_database 1473ucs2_esperanto_ci 1474SET @@global.collation_database = ucs2_hungarian_ci; 1475Warnings: 1476Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1477SELECT @@global.collation_database; 1478@@global.collation_database 1479ucs2_hungarian_ci 1480SET @@global.collation_database = ucs2_unicode_520_ci; 1481Warnings: 1482Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1483SELECT @@global.collation_database; 1484@@global.collation_database 1485ucs2_unicode_520_ci 1486SET @@global.collation_database = cp866_general_ci; 1487Warnings: 1488Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1489SELECT @@global.collation_database; 1490@@global.collation_database 1491cp866_general_ci 1492SET @@global.collation_database = cp866_bin; 1493Warnings: 1494Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1495SELECT @@global.collation_database; 1496@@global.collation_database 1497cp866_bin 1498SET @@global.collation_database = keybcs2_general_ci; 1499Warnings: 1500Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1501SELECT @@global.collation_database; 1502@@global.collation_database 1503keybcs2_general_ci 1504SET @@global.collation_database = keybcs2_bin; 1505Warnings: 1506Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1507SELECT @@global.collation_database; 1508@@global.collation_database 1509keybcs2_bin 1510SET @@global.collation_database = macce_general_ci; 1511Warnings: 1512Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1513SELECT @@global.collation_database; 1514@@global.collation_database 1515macce_general_ci 1516SET @@global.collation_database = macce_bin; 1517Warnings: 1518Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1519SELECT @@global.collation_database; 1520@@global.collation_database 1521macce_bin 1522SET @@global.collation_database = macroman_general_ci; 1523Warnings: 1524Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1525SELECT @@global.collation_database; 1526@@global.collation_database 1527macroman_general_ci 1528SET @@global.collation_database = macroman_bin; 1529Warnings: 1530Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1531SELECT @@global.collation_database; 1532@@global.collation_database 1533macroman_bin 1534SET @@global.collation_database = cp852_general_ci; 1535Warnings: 1536Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1537SELECT @@global.collation_database; 1538@@global.collation_database 1539cp852_general_ci 1540SET @@global.collation_database = cp852_bin; 1541Warnings: 1542Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1543SELECT @@global.collation_database; 1544@@global.collation_database 1545cp852_bin 1546SET @@global.collation_database = latin7_estonian_cs; 1547Warnings: 1548Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1549SELECT @@global.collation_database; 1550@@global.collation_database 1551latin7_estonian_cs 1552SET @@global.collation_database = latin7_general_ci; 1553Warnings: 1554Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1555SELECT @@global.collation_database; 1556@@global.collation_database 1557latin7_general_ci 1558SET @@global.collation_database = latin7_general_cs; 1559Warnings: 1560Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1561SELECT @@global.collation_database; 1562@@global.collation_database 1563latin7_general_cs 1564SET @@global.collation_database = latin7_bin; 1565Warnings: 1566Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1567SELECT @@global.collation_database; 1568@@global.collation_database 1569latin7_bin 1570SET @@global.collation_database = cp1251_bulgarian_ci; 1571Warnings: 1572Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1573SELECT @@global.collation_database; 1574@@global.collation_database 1575cp1251_bulgarian_ci 1576SET @@global.collation_database = cp1251_ukrainian_ci; 1577Warnings: 1578Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1579SELECT @@global.collation_database; 1580@@global.collation_database 1581cp1251_ukrainian_ci 1582SET @@global.collation_database = cp1251_bin; 1583Warnings: 1584Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1585SELECT @@global.collation_database; 1586@@global.collation_database 1587cp1251_bin 1588SET @@global.collation_database = cp1251_general_ci; 1589Warnings: 1590Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1591SELECT @@global.collation_database; 1592@@global.collation_database 1593cp1251_general_ci 1594SET @@global.collation_database = cp1251_general_cs; 1595Warnings: 1596Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1597SELECT @@global.collation_database; 1598@@global.collation_database 1599cp1251_general_cs 1600SET @@global.collation_database = cp1256_general_ci; 1601Warnings: 1602Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1603SELECT @@global.collation_database; 1604@@global.collation_database 1605cp1256_general_ci 1606SET @@global.collation_database = cp1256_bin; 1607Warnings: 1608Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1609SELECT @@global.collation_database; 1610@@global.collation_database 1611cp1256_bin 1612SET @@global.collation_database = cp1257_lithuanian_ci; 1613Warnings: 1614Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1615SELECT @@global.collation_database; 1616@@global.collation_database 1617cp1257_lithuanian_ci 1618SET @@global.collation_database = cp1257_bin; 1619Warnings: 1620Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1621SELECT @@global.collation_database; 1622@@global.collation_database 1623cp1257_bin 1624SET @@global.collation_database = cp1257_general_ci; 1625Warnings: 1626Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1627SELECT @@global.collation_database; 1628@@global.collation_database 1629cp1257_general_ci 1630SET @@global.collation_database = binary; 1631Warnings: 1632Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1633SELECT @@global.collation_database; 1634@@global.collation_database 1635binary 1636SET @@global.collation_database = geostd8_general_ci; 1637Warnings: 1638Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1639SELECT @@global.collation_database; 1640@@global.collation_database 1641geostd8_general_ci 1642SET @@global.collation_database = geostd8_bin; 1643Warnings: 1644Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1645SELECT @@global.collation_database; 1646@@global.collation_database 1647geostd8_bin 1648SET @@global.collation_database = cp932_japanese_ci; 1649Warnings: 1650Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1651SELECT @@global.collation_database; 1652@@global.collation_database 1653cp932_japanese_ci 1654SET @@global.collation_database = cp932_bin; 1655Warnings: 1656Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1657SELECT @@global.collation_database; 1658@@global.collation_database 1659cp932_bin 1660SET @@global.collation_database = eucjpms_japanese_ci; 1661Warnings: 1662Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1663SELECT @@global.collation_database; 1664@@global.collation_database 1665eucjpms_japanese_ci 1666SET @@global.collation_database = eucjpms_bin; 1667Warnings: 1668Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1669SELECT @@global.collation_database; 1670@@global.collation_database 1671eucjpms_bin 1672'#--------------------FN_DYNVARS_016_08-------------------------#' 1673SET @@collation_database = LATIN7_GENERAL_CS; 1674Warnings: 1675Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1676SELECT @@collation_database; 1677@@collation_database 1678latin7_general_cs 1679SET @@collation_database = latin7_general_cs; 1680Warnings: 1681Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1682SELECT @@collation_database; 1683@@collation_database 1684latin7_general_cs 1685SET @@global.collation_database = Latin7_GeneRal_cS; 1686Warnings: 1687Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1688SELECT @@global.collation_database; 1689@@global.collation_database 1690latin7_general_cs 1691'#--------------------FN_DYNVARS_016_09-------------------------#' 1692SET @@collation_database = 1; 1693Warnings: 1694Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1695SELECT @@collation_database; 1696@@collation_database 1697big5_chinese_ci 1698SET @@collation_database = 2; 1699Warnings: 1700Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1701SELECT @@collation_database; 1702@@collation_database 1703latin2_czech_cs 1704SET @@collation_database = 3; 1705Warnings: 1706Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1707SELECT @@collation_database; 1708@@collation_database 1709dec8_swedish_ci 1710SET @@collation_database = 99; 1711Warnings: 1712Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1713SELECT @@collation_database; 1714@@collation_database 1715cp1250_polish_ci 1716SET @@collation_database = 100; 1717ERROR HY000: Unknown collation: '100' 1718SET @@global.collation_database = 1; 1719Warnings: 1720Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1721SELECT @@global.collation_database; 1722@@global.collation_database 1723big5_chinese_ci 1724SET @@global.collation_database = 2; 1725Warnings: 1726Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1727SELECT @@global.collation_database; 1728@@global.collation_database 1729latin2_czech_cs 1730SET @@global.collation_database = 3; 1731Warnings: 1732Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1733SELECT @@global.collation_database; 1734@@global.collation_database 1735dec8_swedish_ci 1736SET @@global.collation_database = 99; 1737Warnings: 1738Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1739SELECT @@global.collation_database; 1740@@global.collation_database 1741cp1250_polish_ci 1742SET @@global.collation_database = 100; 1743ERROR HY000: Unknown collation: '100' 1744SET @total_collations = (SELECT count(*) FROM INFORMATION_SCHEMA.COLLATIONS); 1745SELECT @total_collations > 120; 1746@total_collations > 120 17471 1748'#--------------------FN_DYNVARS_016_10-------------------------#' 1749SET @@collation_database = latin7_binary; 1750ERROR HY000: Unknown collation: 'latin7_binary' 1751SET @@collation_database = 'eucjpms_japanese_cs'; 1752ERROR HY000: Unknown collation: 'eucjpms_japanese_cs' 1753SET @@collation_database = 0; 1754ERROR HY000: Unknown collation: '0' 1755SET @@collation_database = 1.01; 1756ERROR 42000: Incorrect argument type to variable 'collation_database' 1757SET @@collation_database = -1; 1758ERROR HY000: Unknown collation: '-1' 1759SET @@collation_database = ''; 1760ERROR HY000: Unknown collation: '' 1761SET @@collation_database = ' eucjpms_bin'; 1762ERROR HY000: Unknown collation: ' eucjpms_bin' 1763SET @@collation_database = true; 1764Warnings: 1765Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1766SELECT @@collation_database AS res_with_true; 1767res_with_true 1768big5_chinese_ci 1769SET @@collation_database = ON; 1770ERROR HY000: Unknown collation: 'ON' 1771'#--------------------FN_DYNVARS_016_11-------------------------#' 1772SET @@global.collation_database = latin7_binary; 1773ERROR HY000: Unknown collation: 'latin7_binary' 1774SET @@global.collation_database = 'eucjpms_japanese_cs'; 1775ERROR HY000: Unknown collation: 'eucjpms_japanese_cs' 1776SET @@global.collation_database = 0; 1777ERROR HY000: Unknown collation: '0' 1778SET @@global.collation_database = 1.1; 1779ERROR 42000: Incorrect argument type to variable 'collation_database' 1780SET @@global.collation_database = -1; 1781ERROR HY000: Unknown collation: '-1' 1782SET @@global.collation_database = ""; 1783ERROR HY000: Unknown collation: '' 1784SET @@global.collation_database = ' eucjpms_bin'; 1785ERROR HY000: Unknown collation: ' eucjpms_bin' 1786SET @@global.collation_database = true; 1787Warnings: 1788Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1789SET @@global.collation_database = ON; 1790ERROR HY000: Unknown collation: 'ON' 1791'#--------------------FN_DYNVARS_016_12-------------------------#' 1792SELECT @@global.collation_database = 1793(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 1794WHERE VARIABLE_NAME='collation_database') AS res; 1795res 17961 1797SET @@global.collation_database = 1; 1798Warnings: 1799Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1800SELECT @@global.collation_database; 1801@@global.collation_database 1802big5_chinese_ci 1803SELECT @@global.collation_database = 1804(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 1805WHERE VARIABLE_NAME='collation_database') AS res; 1806res 18071 1808'#--------------------FN_DYNVARS_016_13-------------------------#' 1809SELECT @@collation_database = 1810(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES 1811WHERE VARIABLE_NAME='collation_database') AS res; 1812res 18131 1814SELECT @@local.collation_database = 1815(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES 1816WHERE VARIABLE_NAME='collation_database') AS res; 1817res 18181 1819SELECT @@session.collation_database = 1820(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES 1821WHERE VARIABLE_NAME='collation_database') AS res; 1822res 18231 1824SET @@global.collation_database = @global_start_value; 1825Warnings: 1826Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1827SELECT @@global.collation_database; 1828@@global.collation_database 1829latin1_swedish_ci 1830SET @@session.collation_database = @session_start_value; 1831Warnings: 1832Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 1833SELECT @@session.collation_database; 1834@@session.collation_database 1835latin1_swedish_ci 1836