TestStand Test Result Saved as Garbled Characters in MySQL

Updated Feb 5, 2026

Reported In

Software

  • TestStand

Issue Details

My test program consists of Unicode characters. I found that test results with Unicode characters are saved as garbled in the MySQL database. How can I avoid this and have the test result saved as Unicode character in the MySQL database?

Solution

Incorrect database string expression might have caused the Unicode character to be saved wrongly. Kindly ensure the MySQL ODBC Unicode driver is used instead of the ANSI version. Below is a sample of the database string expression using MySQL ODBC Unicode driver.

Driver={MySQL ODBC <version> Unicode Driver};Server=<server IP>;Database=<database name>;User=<user name>;password=<password>

Related Links

Other Support Options

Ask the NI Community

Collaborate with other users in our discussion forums



Request Support from an Engineer

A valid service agreement or active software subscription may be required, and support options vary by country.