<p>I'm making a blog.</p>

<p>I have a wheelform comments input type that needs to be stored as utf8mb4 in the local database.</p>

<p>My MySQL database version 5.6 is configured to utf8mb4 in the database, tables, and columns.</p>

<p>Every time I send an emoji to the database it is stored as four question marks ????.</p>

<p>Is there a way to save emojis correctly in the database? Perhaps using encodeMb4(), but I don't know where and how to apply it.</p>

CC BY-SA 4.0
2019-04-11T02:41:20.117Z
Are you sure all of the textual columns in the database are using `utf8mb4` character set? What is a "wheelform comments input type"? Is that a custom field type coming from a Craft plugin?
Brad Bell
CC BY-SA 4.0
2019-04-11T07:58:46.093Z
Hello @Brad! Yes wheel form is a plugin that gives you form creation in craft 3. And another yes, my database and database server set are in utf8mb4 and the table and column that i need to store emojis are in utf8mb4 also. I check it with show variables mysql query.
André Castro
CC BY-SA 4.0
2019-04-11T23:33:33.943Z
Hrm... never used the plugin before, but maybe they're doing something that's interfering.  `StringHelper::encodeMb4()` should only be needed for non-`utf8mb4` char sets.  Maybe open an issue with them  to see if they can look into it further? https://github.com/xpertbot/craft-wheelform/issues
Brad Bell
<craft3><php><mysql>
Emojis on Craft 3 front office
# Emojis on Craft 3 front office

(Asked by: username_0 on 2019-04-09)

I'm making a blog.

I have a wheelform comments input type that needs to be stored as utf8mb4 in the local database.

My MySQL database version 5.6 is configured to utf8mb4 in the database, tables, and columns.

Every time I send an emoji to the database it is stored as four question marks ????.

Is there a way to save emojis correctly in the database? Perhaps using encodeMb4(), but I don't know where and how to apply it.

**Tags:** craft3, php, mysql

> **Comments:**
> **username_1**: Are you sure all of the textual columns in the database are using `utf8mb4` character set? What is a "wheelform comments input type"? Is that a custom field type coming from a Craft plugin?  
> **username_0**: Hello @Brad! Yes wheel form is a plugin that gives you form creation in craft 3. And another yes, my database and database server set are in utf8mb4 and the table and column that i need to store emojis are in utf8mb4 also. I check it with show variables mysql query.  
> **username_1**: Hrm... never used the plugin before, but maybe they're doing something that's interfering.  `StringHelper::encodeMb4()` should only be needed for non-`utf8mb4` char sets.  Maybe open an issue with them  to see if they can look into it further? https://github.com/xpertbot/craft-wheelform/issues  

---

## 0 answers

