Nodejs Store Emoji in MySQL

Everything should be set to utf8mb4

NodeJS MySQL Connection Pool Charset

json
Wrap|Copy
{
  "charset": "utf8mb4"
}

MySQL Table Character Set

sql
Wrap|Copy
CREATE DATABASE IF NOT EXISTS `<database_name>` CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;