Trying to create ID Based Database Flex Connector
- SmartConnector 8.30
- Database target : MySQL 8.0.25-15
After configuring the flex , the following error appeared in the log file
java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
Tried modifying the JDBC connection string to : jdbc://<SERVERIP>:3306/<DBNAME>?characterEncoding=utf8 , but the problem persisted.
Any ideas ?