Invaild utf8 in 5.7 mysql and not in mysql 5.6

[Rathi Rao]

Hi,

I was using Mysql 5.6.37 and data insertion into the table with string "Sempre que aproxima a época seca fazer quebra was not an issue

The collation details were as follows

show variables like '%collation%'

collation_connection utf8_general_ci
collation_database utf8_general_ci
collation_server latin1_swedish_ci

and the table collation is utf8_unicode_ci

And now , I use 5.7.17. And the same data is not getting inserted into the table

It throws the error, Invalid utf8 character string

It must be noted I am using the ETL tool called talend and using a bulk load component to load the data. The set up worked on mysql 5.6 but is failing for 5.7.

Any help on this please?

Thanks
Rathi