Unknown character set index for field '255' received from server.

[Sabari Vishnu Jayanthan Jaikrishnan]

I am getting this error while creating a data source in the spotfire library. The data source is from My SQL version 8.0.18 and the spotfire version is 7.11.

 

Cannot connect to data source 'database', due to invalid configuration or that the data source is not running.

Database reported:

Unknown character set index for field '255' received from server.

 

 

I tried all possible solutions that I can get from google by using "jdbc:mysql://host:port/databasecharacterEncoding=utf8" , "jdbc:mysql://host:port/databasecharacterEncoding=latin1" but I am getting this error and it is not allowing me to create a data source.

I would need some experts guidance and advice on how to rectify here

Thanks in advance.

[David Boot-Olazabal]

Hi,

 

Did you already check if the driver and the mysql database are of the same version If not, make sure you have both of the same version.

 

kind regards,

 

David