"Unknown initial character" Displayed During Data Loading When TPCCRunner Is Used to Test MySQL

Symptom

When TPCCRunner is used to test MySQL, a message is displayed during TPC-C test environment preparation and data loading. Message details: "Unknown initial character set index '255' received from server. Initial client character set can Exception in thread "main" java.lang.NullPointerException".

Key Process and Cause Analysis

The character set of the MySQL driver is inconsistent with that of the database.

Conclusion and Solution

Modify the conf/example/mysql/loader.properties file to enable the MySQL database connection to use the Unicode character set and use the UTF-8 encoding standard for data transmission.

Open the conf/example/mysql/loader.properties file.
```
vim conf/example/mysql/loader.properties
```
Add the following content to the file:
```
useUnicode=true&characterEncoding=utf8
```
Reload data.

Parent topic: MySQL