1
select @@global.character_sets_dir;
2
@@global.character_sets_dir
4
select @@session.character_sets_dir;
5
ERROR HY000: Variable 'character_sets_dir' is a GLOBAL variable
6
show global variables like 'character_sets_dir';
8
character_sets_dir MYSQL_CHARSETSDIR
9
show session variables like 'character_sets_dir';
11
character_sets_dir MYSQL_CHARSETSDIR
12
select * from information_schema.global_variables where variable_name='character_sets_dir';
13
VARIABLE_NAME VARIABLE_VALUE
14
CHARACTER_SETS_DIR MYSQL_CHARSETSDIR
15
select * from information_schema.session_variables where variable_name='character_sets_dir';
16
VARIABLE_NAME VARIABLE_VALUE
17
CHARACTER_SETS_DIR MYSQL_CHARSETSDIR
18
set global character_sets_dir="foo";
19
ERROR HY000: Variable 'character_sets_dir' is a read only variable
20
set session character_sets_dir="foo";
21
ERROR HY000: Variable 'character_sets_dir' is a read only variable