Strapi Save Emoji as ???? (Question marks) in MySql Database

[iKunalmathur]

Bug report

Describe the bug

Strapi Save Emoji as ???? (Question marks) in MySql Database

Steps to reproduce the behavior

1. Download 'https://github.com/strapi/strapi-starter-next-blog'
2. Connect with database in my case which is MySql
3. Create a new article add a description containing Emoji(🙄).
4. See error: Strapi Save Emoji As ???? in database.

Screenshots

Bug Image

System

• Strapi Version: 3.6.5
• Operating System: Windows 10
• Database: MySQL
• Node Version: 14.17.0
• NPM Version: 6.14.13
• Yarn Version: none

Additional context

it works fine with the default database (SQLite)

[derrickmehaffy]

Can you please confirm what char encoding your MySQL database is set to?

As MySQL defaults to latin1 / latin1_swedish_ci instead of utf8mb4.

[iKunalmathur]

@derrickmehaffy Hi Thanks for the response but I've changed encoding to utf8mb4_unicode_ci in phpMyAdmin but still, it doesn't work.

[derrickmehaffy]

Make sure the database and the table are set to utf8mb4 and keep in mind that by changing that doesn't change the currently stored data, only new data will have that encoding.

[iKunalmathur]

still don't work

[Milesssssss]

Still don`t work!!

[iKunalmathur]

hey @machengda89 which database you are using??

[pierredarrieutort]

Hey, try to follow #10468 (comment).

1 - change wanted columns to utf8mb4_unicode_ci :

2 - In /config/database.js go to connections.default.settings and add charset: 'utf8mb4'

It works for me

[themtaysw]

Hey, try to follow #10468 (comment).

1 - change wanted columns to utf8mb4_unicode_ci :

2 - In /config/database.js go to connections.default.settings and add charset: 'utf8mb4'

It works for me

works in a certain way for me... it tends to save some emojis normally, tho some of them are still as ????. any possible solution?

[danieltorres1109]

I add two lines on config/database:

charset: 'utf8mb4',
collation: 'utf8mb4_unicode_ci'

My code looks as:
mysql: { connection: { connectionString: env('DATABASE_URL'), host: env('DATABASE_HOST', 'localhost'), port: env.int('DATABASE_PORT', 3306), database: env('DATABASE_NAME', 'strapi'), user: env('DATABASE_USERNAME', 'strapi'), charset: 'utf8mb4', collation: 'utf8mb4_unicode_ci', password: env('DATABASE_PASSWORD', 'strapi'), ssl: env.bool('DATABASE_SSL', false) && { key: env('DATABASE_SSL_KEY', undefined), cert: env('DATABASE_SSL_CERT', undefined), ca: env('DATABASE_SSL_CA', undefined), capath: env('DATABASE_SSL_CAPATH', undefined), cipher: env('DATABASE_SSL_CIPHER', undefined), rejectUnauthorized: env.bool( 'DATABASE_SSL_REJECT_UNAUTHORIZED', true ), }, }, pool: { min: env.int('DATABASE_POOL_MIN', 2), max: env.int('DATABASE_POOL_MAX', 10) }, },

[red-made]

I've done the following:

1- added, as mentioned before, in config/database:

charset: 'utf8mb4',
collation: 'utf8mb4_unicode_ci'

2- Edited the column:

ALTER TABLE
    table_name
    CHANGE column_name column_name
    LONGTEXT
    CHARACTER SET utf8mb4
    COLLATE utf8mb4_unicode_ci;

3- Edited the table:

ALTER TABLE
    table_name
    CONVERT TO CHARACTER SET utf8mb4
    COLLATE utf8mb4_unicode_ci;

It's working like a charm