I am having a strange problem using mySQL via ADO.

I have written a medium sized LabVIEW app that uses mySQL as a back end. It works perfectly at the customer site, on many, many XP machines.

When I connect my laptop to the network, on all permutations of XP, VISTA and LV7.1.1 and LabVIEW 8.5, any column results that were created with a CONCAT or GROUP_CONCAT function appear something like this: "?????+????++??".

I have even installed the DB locally in case it was some sort of network problem, but I still see it. I thought it might be something to do with the default character set, but it occurs when I connect to the same server. I cut/pasted the query out of a labview probe into mySQL Query Browser and it had no problem.

I see the bad results as soon as the Variant is cast with the DB function...