---
title: "Nodejs Store Emoji in MySQL"
date: 2021-12-29T18:08:50.000Z
author: Z.SHINCHVEN
tags: [Node.js, mysql, emoji]
canonical: https://atlassc.net/2021/12/30/nodejs-store-emoji-in-mysql
---
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;
```