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
Subject
Views
Written By
Posted
Invaild utf8 in 5.7 mysql and not in mysql 5.6
1581
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.