MySQL Variables character_set_filesystem 数据库 参数变量解释及正确配置使用

本站中文解释

MySQL参数变量character_set_filesystem指定MySQL服务器在对外部文件系统进行操作时使用的字符集。这个字符集用于MySQL中的LOAD DATA或SELECT … INTO OUTFILE命令访问文件系统时的文件名编码。

要设置和更改MySQL参数character_set_filesystem的值，需要将以下SQL查询语句发送到MySQL服务器：

SET GLOBAL character_set_filesystem=;

这将设置character_set_filesystem的值为给定的字符集名称（）。

官方英文解释

character_set_filesystem

The file system character set. This variable is used to
interpret string literals that refer to file names, such as in
the LOAD DATA and
SELECT ... INTO
OUTFILE statements and the
LOAD_FILE() function. Such file
names are converted from
character_set_client to
character_set_filesystem
before the file opening attempt occurs. The default value is
binary, which means that no conversion
occurs. For systems on which multibyte file names are
permitted, a different value may be more appropriate. For
example, if the system represents file names using UTF-8, set
character_set_filesystem to
'utf8mb4'.