Forum Discussion

白夜有点黑's avatar
白夜有点黑
Contributor
5 years ago
Solved

Junk characters in SoapUI [DataSource] - [Data Connection] - [SQL Query] , how to handle this?

I need use Chinese Chars in SoapUI Pro [DataSource Step] - [Data Connection] - [SQL Query] command, but it shows junk characters here and the query result is null, how to handle this issue?   The...
  • 白夜有点黑's avatar
    白夜有点黑
    5 years ago

    I finally got the solution like below:

     

    This junk characters issue can be solved by update editor font setting:

    File -> Preferences -> Editor Settings

    Editor Font = Microsoft YaHei UI Light

     

    And the other issue which got 0 rows result in JDBC step if the sql command contains Chinese Chars can be sloved by update mysql connect String like "jdbc:mysql://<HOST:127.0.0.1>:<PORT:3306>/<DB>?user=<USER>&password=<PASSWORD>&characterEncoding=UTF8"