Help us understand the problem. What is going on with this article?

Amazon RDS(MySQL)でutf8mb4を使いたい場合の設定

More than 1 year has passed since last update.

ちょいちょい忘れるのでメモ。

パラメータグループで下記を設定

character_set_client:utf8mb4
character_set_connection:utf8mb4
character_set_database:utf8mb4
character_set_results:utf8mb4
character_set_server:utf8mb4
innodb_large_prefix:1
innodb_file_format:Barracuda
innodb_file_per_table:1

確認

DB再起動してshow variables like 'character_set%';叩いて変わってればOK

その他

上記設定後、character_set_databaseがlatin1になってしまう現象があったが、下記で解決。
ALTER DATABASE dbname default character set utf8mb4;

Why not register and get more from Qiita?
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away
Comments
No comments
Sign up for free and join this conversation.
If you already have a Qiita account
Why do not you register as a user and use Qiita more conveniently?
You need to log in to use this function. Qiita can be used more conveniently after logging in.
You seem to be reading articles frequently this month. Qiita can be used more conveniently after logging in.
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away
ユーザーは見つかりませんでした