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