KNOWLEDGE BASE

Null Values Displayed for VARCHAR Column in MySQL


Published: 31 Mar 2016
Last Modified Date: 11 Aug 2017

Issue

When you connect to a MySQL database, a column with VARCHAR data type might show all null data. 

Environment

  • Tableau Desktop
  • MySQL

Resolution

Remove the leading space from the column name. 

Cause

Known issue caused by a leading space in the name of the column on the MySQL side. 
Did this article resolve the issue?