I know the JET driver has a 256 char limit - A string created in Tableau does not have this limit, so I wonder if the MYSQL driver is truncating it?
A quick Google search does seem to imply that.
Just out of curiosity - what are you hoping to analyze out of the XML?
I work for a finance company and I'm trying to quickly see which of our customers have saved settings for specific exchanges. The corresponding xml can have multiple destinations integrated into one ticket, making it a very long string.
Do you think there is a different MySQL driver that I could be using? I see the entire field when I look at the data in DB Visualizer. Is it even possible to tell Tableau to use a different driver?
No idea - though I wonder if you could use custom SQL or a view to create a table with the exchange names extracted?