MySQL Forums
Forum List  »  Newbie

Re: Incorrect String Value
Posted by: Peter Brawley
Date: April 11, 2022 09:08PM

There's a character set mismatch between data in the csv file and the table

Before issuing the Load Data command, have you issued this cmd?

set names 'utf8mb4';

Let's see ...

- the Show Create Table result for that table, and the line that the import is tripping over

- the result of ...

show variables like '%char%';

Options: ReplyQuote


Subject
Written By
Posted
April 11, 2022 08:57PM
Re: Incorrect String Value
April 11, 2022 09:08PM
April 12, 2022 10:13AM
April 12, 2022 10:33AM
April 12, 2022 12:35PM
April 12, 2022 04:26PM
April 12, 2022 07:45PM
April 12, 2022 08:03PM
April 13, 2022 05:34PM
April 13, 2022 10:09PM
April 14, 2022 06:07PM


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.