ireport sql problem unknown intial character set 255 code example

Example: java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.

Please add ?characterEncoding=latin1 like this way "jdbc:mysql://localhost/yourDB?characterEncoding=latin1";