mysqlの文字コード設定について
my.iniで文字コードをutf8に変更しmysqlを再起動し、show variables like 'char%';で表示して確認してみたのですが、character_set_clientとcharacter_set_connectionの文字コードはcp932のままです。
# CLIENT SECTION # ---------------------------------------------------------------------- # # The following options will be read by MySQL client applications. # Note that only client applications shipped by MySQL are guaranteed # to read this section. If you want your own MySQL client program to # honor these values, you need to specify it as an option during the # MySQL client library initialization. #[client] # pipe= # socket=MYSQL port=3306 [mysql] no-beep default-character-set=utf8 # SERVER SECTION # ---------------------------------------------------------------------- # # The following options will be read by the MySQL Server. Make sure that # you have installed the server correctly (see above) so it reads this # file. # # server_type=3 [mysqld] # The next three options are mutually exclusive to SERVER_PORT below. # skip-networking # enable-named-pipe # shared-memory # shared-memory-base-name=MYSQL # The Pipe the MySQL Server will use # socket=mysql=MYSQL # The TCP/IP Port the MySQL Server will listen on port=3306 # Path to installation directory. All paths are usually resolved relative to this. # basedir="C:/Program Files/MySQL/MySQL Server 8.0/" # Path to the database root datadir=C:/ProgramData/MySQL/MySQL Server 8.0/Data # The default character set that will be used when a new schema or table is # created and no character set is defined character-set-server=utf8 # The default authentication plugin to be used when connecting to the server default_authentication_plugin=caching_sha2_password
参考にしたサイトです。↓
https://www.dbonline.jp/mysql/myini/index3.html
解決方法がわからないので教えて頂ければ幸いです。
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。
2018/08/14 12:34