When you execute search at splunk web, try these search commands :
| Mysqlquery spec = splunk_test query = "SELECT code, cast(name as binary) FROM test_table;"
or
| Mysqlquery spec = splunk_test query = "SELECT code, convert(name using utf8) FROM test_table;"
... View more