Do one thing, In Tableau, in the data view change the Data type to String.
Thanks Deepak. In the first tableau screenshot I posted, the data type is set to string. It shows as blank when I set it to string. That's essentially the problem I am facing
Do yo have some dataset? I would check here.
2 of 2 people found this helpful
Below article suggest this - Did you already try this?
Remove the leading space from the column name.
Try opening a brand new workbook and reconnecting to the data source and see if the data can now be viewed correctly.
Maybe something had changed in the data source since connecting to it via Tableau.
Try to use extract connection instead of live.
3 of 3 people found this helpful
I am having the same problem with MySQL8. Casting each column manually: CAST(text AS CHAR(10000) CHARACTER SET utf8) works but I should not have to do this.
You can fix the issue (if you manage the database) by running some SQL commands:
This will convert the default schema but will not change existing data
ALTER SCHEMA `YOUR_DATABASE` DEFAULT COLLATE utf8_bin ; -- this will make sure new tables use utf8 instead of the default utf8mb4
Now you can convert the tables you need which will alter existing data
ALTER TABLE `YOUR_DATABASE`.`YOUR_TABLE` CONVERT TO CHARACTER SET UTF8MB3; -- coerce existing data back to utf8
This does mean any 4 byte utf8 data like emojis will be lost
Looks like this is a character set issue. And Matt's solution is working for me.