KNOWLEDGE BASE

Emojis do not display as expected in Tableau Desktop "unknown character" when connecting to MySQL


Published: 21 Oct 2020
Last Modified Date: 08 Oct 2021

Issue

Emojis and/or mathematical alphanumeric symbols display as squares or ? in Tableau Desktop. MySQL encoding is set to utf8mb4.

Environment

  • Tableau Desktop

Resolution

As a workaround, connect using a JDBC driver from Tableau Desktop to pull in the columns that are using characters "utf8mb4 encoding" that the native driver cannot parse.

1. Downloaded and install the right JDBC driver for the appropriate OS. Note:JDBC drivers are self-contained .jar files. Place the .jar files in the folder for your operating system. 
2. Connected to MySql from Tableau Desktop using Other Databases (JDBC). URL field example:
jdbc:mysql://<servername>:3306/<databasename>
Detailed information can be found here : https://help.tableau.com/current/pro/desktop/en-us/examples_otherdatabases_jdbc.htm


 

Cause

This is a limitation of the MySql8 driver. 

Additional Information

It is possible to Add another connection to the same MySQL table in in the Data Source page using Tableau Desktop the MySQL connector, so to use only fields containing emojis/special from the data source using the JDBC connector.
Did this article resolve the issue?