LoginSignup
2
5

More than 5 years have passed since last update.

mysqlでDBに保存した日本語が?で表示されてしまう

Posted at

■DBを選択してからテーブルの文字コードを変更する

mysql> use db_name;
mysql> alter table table_name convert to character set utf8 collate utf8_general_ci;

※補足

■文字コードを確認

mysql> show variables like "chara%";

■DB等の文字コードを変更

mysql> set character_set_database = utf8;
mysql> set character_set_client = utf8;
mysql> set character_set_connection = utf8;
mysql> set character_set_results = utf8;
mysql> set character_set_server = utf8;

※globalで変更したい場合はsetの後ろにglobalを付ける

2
5
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
2
5