Nodejs Store Emoji in MySQL

Wed Dec 29 2021

Everything should be set to utf8mb4

NodeJS MySQL Connection Pool Charset

json
|
{ "charset": "utf8mb4" }

MySQL Table Character Set

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