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 'global.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 = gb18030; 154SELECT @@session.character_set_filesystem; 155@@session.character_set_filesystem 156gb18030 157SET @@session.character_set_filesystem = latin5; 158SELECT @@session.character_set_filesystem; 159@@session.character_set_filesystem 160latin5 161SET @@session.character_set_filesystem = armscii8; 162SELECT @@session.character_set_filesystem; 163@@session.character_set_filesystem 164armscii8 165SET @@session.character_set_filesystem = utf8; 166SELECT @@session.character_set_filesystem; 167@@session.character_set_filesystem 168utf8 169SET @@session.character_set_filesystem = ucs2; 170SELECT @@session.character_set_filesystem; 171@@session.character_set_filesystem 172ucs2 173SET @@session.character_set_filesystem = cp866; 174SELECT @@session.character_set_filesystem; 175@@session.character_set_filesystem 176cp866 177SET @@session.character_set_filesystem = keybcs2; 178SELECT @@session.character_set_filesystem; 179@@session.character_set_filesystem 180keybcs2 181SET @@session.character_set_filesystem = macce; 182SELECT @@session.character_set_filesystem; 183@@session.character_set_filesystem 184macce 185SET @@session.character_set_filesystem = macroman; 186SELECT @@session.character_set_filesystem; 187@@session.character_set_filesystem 188macroman 189SET @@session.character_set_filesystem = cp852; 190SELECT @@session.character_set_filesystem; 191@@session.character_set_filesystem 192cp852 193SET @@session.character_set_filesystem = latin7; 194SELECT @@session.character_set_filesystem; 195@@session.character_set_filesystem 196latin7 197SET @@session.character_set_filesystem = cp1251; 198SELECT @@session.character_set_filesystem; 199@@session.character_set_filesystem 200cp1251 201SET @@session.character_set_filesystem = cp1256; 202SELECT @@session.character_set_filesystem; 203@@session.character_set_filesystem 204cp1256 205SET @@session.character_set_filesystem = cp1257; 206SELECT @@session.character_set_filesystem; 207@@session.character_set_filesystem 208cp1257 209SET @@session.character_set_filesystem = binary; 210SELECT @@session.character_set_filesystem; 211@@session.character_set_filesystem 212binary 213SET @@session.character_set_filesystem = geostd8; 214SELECT @@session.character_set_filesystem; 215@@session.character_set_filesystem 216geostd8 217SET @@session.character_set_filesystem = cp932; 218SELECT @@session.character_set_filesystem; 219@@session.character_set_filesystem 220cp932 221SET @@session.character_set_filesystem = eucjpms; 222SELECT @@session.character_set_filesystem; 223@@session.character_set_filesystem 224eucjpms 225'#--------------------FN_DYNVARS_008_07-------------------------#' 226SET @@global.character_set_filesystem = big5; 227SELECT @@global.character_set_filesystem; 228@@global.character_set_filesystem 229big5 230SET @@global.character_set_filesystem = dec8; 231SELECT @@global.character_set_filesystem; 232@@global.character_set_filesystem 233dec8 234SET @@global.character_set_filesystem = cp850; 235SELECT @@global.character_set_filesystem; 236@@global.character_set_filesystem 237cp850 238SET @@global.character_set_filesystem = hp8; 239SELECT @@global.character_set_filesystem; 240@@global.character_set_filesystem 241hp8 242SET @@global.character_set_filesystem = koi8r; 243SELECT @@global.character_set_filesystem; 244@@global.character_set_filesystem 245koi8r 246SET @@global.character_set_filesystem = latin1; 247SELECT @@global.character_set_filesystem; 248@@global.character_set_filesystem 249latin1 250SET @@global.character_set_filesystem = latin2; 251SELECT @@global.character_set_filesystem; 252@@global.character_set_filesystem 253latin2 254SET @@global.character_set_filesystem = swe7; 255SELECT @@global.character_set_filesystem; 256@@global.character_set_filesystem 257swe7 258SET @@global.character_set_filesystem = ascii; 259SELECT @@global.character_set_filesystem; 260@@global.character_set_filesystem 261ascii 262SET @@global.character_set_filesystem = ujis; 263SELECT @@global.character_set_filesystem; 264@@global.character_set_filesystem 265ujis 266SET @@global.character_set_filesystem = sjis; 267SELECT @@global.character_set_filesystem; 268@@global.character_set_filesystem 269sjis 270SET @@global.character_set_filesystem = hebrew; 271SELECT @@global.character_set_filesystem; 272@@global.character_set_filesystem 273hebrew 274SET @@global.character_set_filesystem = tis620; 275SELECT @@global.character_set_filesystem; 276@@global.character_set_filesystem 277tis620 278SET @@global.character_set_filesystem = euckr; 279SELECT @@global.character_set_filesystem; 280@@global.character_set_filesystem 281euckr 282SET @@global.character_set_filesystem = koi8u; 283SELECT @@global.character_set_filesystem; 284@@global.character_set_filesystem 285koi8u 286SET @@global.character_set_filesystem = gb2312; 287SELECT @@global.character_set_filesystem; 288@@global.character_set_filesystem 289gb2312 290SET @@global.character_set_filesystem = greek; 291SELECT @@global.character_set_filesystem; 292@@global.character_set_filesystem 293greek 294SET @@global.character_set_filesystem = cp1250; 295SELECT @@global.character_set_filesystem; 296@@global.character_set_filesystem 297cp1250 298SET @@global.character_set_filesystem = gbk; 299SELECT @@global.character_set_filesystem; 300@@global.character_set_filesystem 301gbk 302SET @@global.character_set_filesystem = gb18030; 303SELECT @@global.character_set_filesystem; 304@@global.character_set_filesystem 305gb18030 306SET @@global.character_set_filesystem = latin5; 307SELECT @@global.character_set_filesystem; 308@@global.character_set_filesystem 309latin5 310SET @@global.character_set_filesystem = armscii8; 311SELECT @@global.character_set_filesystem; 312@@global.character_set_filesystem 313armscii8 314SET @@global.character_set_filesystem = utf8; 315SELECT @@global.character_set_filesystem; 316@@global.character_set_filesystem 317utf8 318SET @@global.character_set_filesystem = ucs2; 319SELECT @@global.character_set_filesystem; 320@@global.character_set_filesystem 321ucs2 322SET @@global.character_set_filesystem = cp866; 323SELECT @@global.character_set_filesystem; 324@@global.character_set_filesystem 325cp866 326SET @@global.character_set_filesystem = keybcs2; 327SELECT @@global.character_set_filesystem; 328@@global.character_set_filesystem 329keybcs2 330SET @@global.character_set_filesystem = macce; 331SELECT @@global.character_set_filesystem; 332@@global.character_set_filesystem 333macce 334SET @@global.character_set_filesystem = macroman; 335SELECT @@global.character_set_filesystem; 336@@global.character_set_filesystem 337macroman 338SET @@global.character_set_filesystem = cp852; 339SELECT @@global.character_set_filesystem; 340@@global.character_set_filesystem 341cp852 342SET @@global.character_set_filesystem = latin7; 343SELECT @@global.character_set_filesystem; 344@@global.character_set_filesystem 345latin7 346SET @@global.character_set_filesystem = cp1251; 347SELECT @@global.character_set_filesystem; 348@@global.character_set_filesystem 349cp1251 350SET @@global.character_set_filesystem = cp1256; 351SELECT @@global.character_set_filesystem; 352@@global.character_set_filesystem 353cp1256 354SET @@global.character_set_filesystem = cp1257; 355SELECT @@global.character_set_filesystem; 356@@global.character_set_filesystem 357cp1257 358SET @@global.character_set_filesystem = binary; 359SELECT @@global.character_set_filesystem; 360@@global.character_set_filesystem 361binary 362SET @@global.character_set_filesystem = geostd8; 363SELECT @@global.character_set_filesystem; 364@@global.character_set_filesystem 365geostd8 366SET @@global.character_set_filesystem = cp932; 367SELECT @@global.character_set_filesystem; 368@@global.character_set_filesystem 369cp932 370SET @@global.character_set_filesystem = eucjpms; 371SELECT @@global.character_set_filesystem; 372@@global.character_set_filesystem 373eucjpms 374'#--------------------FN_DYNVARS_008_08-------------------------#' 375SET @@character_set_filesystem = UTF8; 376SELECT @@character_set_filesystem; 377@@character_set_filesystem 378utf8 379SET @@character_set_filesystem = utf8; 380SELECT @@character_set_filesystem; 381@@character_set_filesystem 382utf8 383SET @@character_set_filesystem = uTf8; 384SELECT @@character_set_filesystem; 385@@character_set_filesystem 386utf8 387'#--------------------FN_DYNVARS_008_09-------------------------#' 388SET @@character_set_filesystem = 1; 389SELECT @@character_set_filesystem; 390@@character_set_filesystem 391big5 392SET @@character_set_filesystem = 2; 393SELECT @@character_set_filesystem; 394@@character_set_filesystem 395latin2 396SET @@character_set_filesystem = 3; 397SELECT @@character_set_filesystem; 398@@character_set_filesystem 399dec8 400SET @@character_set_filesystem = 36; 401SELECT @@character_set_filesystem; 402@@character_set_filesystem 403cp866 404SET @@character_set_filesystem = 99; 405SELECT @@character_set_filesystem; 406@@character_set_filesystem 407cp1250 408SET @@character_set_filesystem = 100; 409ERROR 42000: Unknown character set: '100' 410SET @total_charset = (SELECT count(*) FROM INFORMATION_SCHEMA.CHARACTER_SETS); 411SELECT @total_charset; 412@total_charset 41341 414'#--------------------FN_DYNVARS_008_10-------------------------#' 415SET @@character_set_filesystem = abc; 416ERROR 42000: Unknown character set: 'abc' 417SET @@character_set_filesystem = 1utf8; 418ERROR 42000: Unknown character set: '1utf8' 419SET @@character_set_filesystem = 0; 420ERROR 42000: Unknown character set: '0' 421SET @@character_set_filesystem = 1.1; 422ERROR 42000: Incorrect argument type to variable 'character_set_filesystem' 423SET @@character_set_filesystem = -1; 424ERROR 42000: Unknown character set: '-1' 425SET @@character_set_filesystem = ''; 426ERROR 42000: Unknown character set: '' 427SET @@character_set_filesystem = 'utf'; 428ERROR 42000: Unknown character set: 'utf' 429SET @@character_set_filesystem = true; 430SELECT @@character_set_filesystem AS res_with_true; 431res_with_true 432big5 433SET @@character_set_filesystem = ON; 434ERROR 42000: Unknown character set: 'ON' 435'#--------------------FN_DYNVARS_008_11-------------------------#' 436SET @@global.character_set_filesystem = abc; 437ERROR 42000: Unknown character set: 'abc' 438SET @@global.character_set_filesystem = 1utf8; 439ERROR 42000: Unknown character set: '1utf8' 440SET @@global.character_set_filesystem = 0; 441ERROR 42000: Unknown character set: '0' 442SET @@global.character_set_filesystem = 1.1; 443ERROR 42000: Incorrect argument type to variable 'character_set_filesystem' 444SET @@global.character_set_filesystem = -1; 445ERROR 42000: Unknown character set: '-1' 446SET @@global.character_set_filesystem = ''; 447ERROR 42000: Unknown character set: '' 448SET @@global.character_set_filesystem = 'utf'; 449ERROR 42000: Unknown character set: 'utf' 450SET @@global.character_set_filesystem = true; 451SET @@global.character_set_filesystem = ON; 452ERROR 42000: Unknown character set: 'ON' 453'#--------------------FN_DYNVARS_008_12-------------------------#' 454SELECT @@global.character_set_filesystem = 455(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 456WHERE VARIABLE_NAME='character_set_filesystem') AS res; 457res 4581 459SET @@global.character_set_filesystem = 1; 460SELECT @@global.character_set_filesystem; 461@@global.character_set_filesystem 462big5 463SELECT @@global.character_set_filesystem = 464(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 465WHERE VARIABLE_NAME='character_set_filesystem') AS res; 466res 4671 468'#--------------------FN_DYNVARS_008_13-------------------------#' 469SELECT @@character_set_filesystem = 470(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES 471WHERE VARIABLE_NAME='character_set_filesystem') AS res; 472res 4731 474SELECT @@local.character_set_filesystem = 475(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES 476WHERE VARIABLE_NAME='character_set_filesystem') AS res; 477res 4781 479SELECT @@session.character_set_filesystem = 480(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES 481WHERE VARIABLE_NAME='character_set_filesystem') AS res; 482res 4831 484SET @@global.character_set_filesystem = @global_start_value; 485SELECT @@global.character_set_filesystem; 486@@global.character_set_filesystem 487binary 488SET @@session.character_set_filesystem = @session_start_value; 489SELECT @@session.character_set_filesystem; 490@@session.character_set_filesystem 491binary 492