KNOWLEDGE BASE

4-Byte Emoji Or 4-Byte Characters Render Incorrectly


Published: 24 Sep 2021
Last Modified Date: 08 Oct 2021

Issue

When there are 4-Byte Emoji or 4-Byte characters in a MySQL or Aurora MySQL tables used as data sources, the 4-Byte Emoji or 4-Byte characters will render as a question mark (?) in Tableau Desktop and Tableau Server.

Environment

  • Tableau Server
  • Tableau Desktop
  • MySQL or Aurora MySQL
  • MySQL ODBC driver 8.0.26

Resolution

Option 1

Use the JDBC driver instead.

Option 2

Wait for MySQL Connector/ODBC 8.0.27 release and update the MySQL ODBC driver to 8.0.27.

Cause

MySQL ODBC 8.0 Unicode Driver Fails to Return 4-Byte Emoji from Database.
Did this article resolve the issue?