MySQL Forums
Forum List  »  Newbie

Incorrect String Value
Posted by: Tames Bond
Date: April 11, 2022 08:57PM

I am trying to import a tsv file into mysql 8 but it keeps giving an error on a small e with an acute accent hex code \xE9.
I am using mysql 8.0 command line client unicode.
I have the table set to utf8mb4 with collate utf8mb4_0900_ai_ci.
The column is set to varchar(60) utf8mb4 collate the same as above.
I have tried a lot of different collate codes but they all fail.
What am I missing?

Options: ReplyQuote


Subject
Written By
Posted
Incorrect String Value
April 11, 2022 08:57PM
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.