CODEWITHSUNDEEP
mysqldatabaseemojinavicat
James Logan
James Logan

Reputation: 831

How to include emoji's in utf8mb4_general_ci coded DB? (MySQL issue)

I'm trying via various DB software (Navicat, MySQL Workbench and others) to include an emoji in the table row along with text. The table is utf8mb4_general_ci, so it should work, but it ends up showing as ???? or ?. What is the trick here to include the emoji icons directly?

Upvotes: 1

Views: 1141

Answers (1)

Leandro Ferrero
Leandro Ferrero

Reputation: 133

The versions of navicat < 11.1 don't work.

Use the newest version of Navicat and go to Edit Connection > Advanced > Encoding and Select 65001 (UTF-8). (This enables to you to insert emojis on the database, try copy/paste from web.whatsapp.com for testing) You will see empty Squares.

Then go to tools > grid font > Segoe UI Symbol (this will show only a utf-7 emojis)

Upvotes: 1

Related Questions