Handling Non english character in on-prem control hub

Product:  StreamSets Control Hub 

Issue:

Non-English character replaced with `???`

Versions affected:

On-prem Streamsets Control Hub ( < 3.20.X)

Solution:

• Make sure your backend database  character set encoding to UTF-8
• Also specify the encoding scheme as UTF-8 in the connection URL for all  * app. properties 

 useUnicode=yes&characterEncoding=UTF-8

For e.g, the connection URL should look like

db.openjpa.ConnectionURL=jdbc:mysql://<DB_URL>:3306/scjobs_cloud?useUnicode=yes&characterEncoding=UTF-8