Rails(utf-8编码问题)：活动记录错误地获取msyqldb数据

-- 创建数据库时指定字符集
CREATE DATABASE my_database CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 修改现有数据库字符集
ALTER DATABASE my_database CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 创建表时指定字符集
CREATE TABLE my_table (
  id INT PRIMARY KEY,
  name VARCHAR(255)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 修改现有表字符集
ALTER TABLE my_table CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

default: &default
  adapter: mysql2
  encoding: utf8mb4
  pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>
  username: your_mysql_username
  password: your_mysql_password
  socket: /var/run/mysqld/mysqld.sock

development:
  <<: *default
  database: my_database_development

test:
  <<: *default
  database: my_database_test

production:
  <<: *default
  database: my_database_production
  username: my_database
  password: <%= ENV['MY_DATABASE_PASSWORD'] %>

# app/models/my_model.rb
class MyModel < ApplicationRecord
  # 确保没有指定错误的字符集
end

# db/migrate/xxxx_xx_xx_xxxxxx_create_my_table.rb
class CreateMyTable < ActiveRecord::Migration[6.1]
  def change
    create_table :my_tables do |t|
      t.string :name, limit: 255
      t.timestamps
    end
  end
end

rails restart