Invaild utf8 in 5.7 mysql and not in mysql 5.6
Posted by: Rathi Rao
Date: May 02, 2018 07:36AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Invaild utf8 in 5.7 mysql and not in mysql 5.6
811
May 02, 2018 07:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.