MySQL Forums
Forum List  »  Newbie

Re: Incorrect String Value
Posted by: Peter Brawley
Date: April 12, 2022 08:03PM

?! As expected, running the Create Table code that you posted against MySQL 8.0.27, in WorkBench, elicits the error ...

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''addresses' (

... and running it again after that first error is corrected, the next error is reported, and so on.

Quote

The original error flags on line 8 so it has no problem reading the previous seven lines it is just the é that is giving the problem.

You'll need to suss out the charset of that input line.

Options: ReplyQuote


Subject
Written By
Posted
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
Re: Incorrect String Value
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.