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