SQL exams database problem
When I download the albums database and tried to run the database. Everything works fine except when I try to insert values into the 'artists' table. An error pops up; Error Code: 1366. Incorrect string value: '\xC4\x81vis' for column 'artist_last_name' at row 37. I didn't change anything in the downloaded database. Not really sure how to correct this issue. I was not able to do anything relating to or involving the 'artists' table.
Thanks for reaching out.
Please excuse us for the belated answer.
Throughout the course, there's no point in which there is a table called 'artists'. Are you referring to the exams? At what stage do you need/want to add records to this table?
Also, please let us know which code you executed to obtain the given error message.
Looking forward to your answer.
It was the exam. I downloaded the given database (db-albums.sql) for the exams and when I ran it to create the tables, the error came up. I wasn't adding records to the table, the table didn't create at all when I ran the given db-albums. I downloaded the given database and click the lighting icon to execute the commands and the error (Error Code: 1366. Incorrect string value: '\xC4\x81vis' for column 'artist_last_name' at row 37) came up at the end. When I ran this code, SELECT * FROM albums.artists; 0 rows returned and there is nothing in the table.
Thanks for your reply.
This is an interesting issue we have not come across on our end, nor has a student complained about it so far; which makes me think it may be a local issue.
Can you please re-connect to the database, restart MySQL Workbench, and retry to add the data from the 'albums' database again? Does that help?
Here's how you can reconnect to the database:
Hope this helps but please feel free to get back to us should you need further assistance. Thank you.