Error: Incorrect string value: '\xF0\x9D\x95\x92\xF0\x9D...'

thanhbinh87 · April 25, 2022, 4:12am

I add 2 lines for database connect:

charset   : 'utf8mb4',
      collation : 'utf8mb4_unicode_ci'

on file config/database.js. Here is full file after changed:

module.exports = ({ env }) => ({
  connection: {
    client: 'mysql',
    connection: {
      host: env('DATABASE_HOST', '127.0.0.1'),
      port: env.int('DATABASE_PORT', 3306),
      database: env('DATABASE_NAME', 'your-db-name'),
      user: env('DATABASE_USERNAME', 'root'),
      password: env('DATABASE_PASSWORD', ''),
      ssl: env.bool('DATABASE_SSL', false),
      charset   : 'utf8mb4',
      collation : 'utf8mb4_unicode_ci'
    },
  },
});

and alter your dabase table by MySQL command:

ALTER TABLE tablename CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

after that you can check it by command:

SHOW FULL COLUMNS FROM table_name;

Now you can see database table same my screenshot:

My issues solved!