MySQL Bugs: #106951: Some values in SAKILA example database are damaged

Bug #106951	Some values in SAKILA example database are damaged
Submitted:	8 Apr 2022 5:51	Modified:	4 Oct 2022 21:02
Reporter:	Владислав Сокол	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	8.0.28	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	sakila

Description:
The data in the sample database SAKILA is damaged. All values which should contain symbols á, â, ç, é, İ, í, ñ, ó, ö, š and so on - are damaged.

For example, the INSERT statement which inserts the most first row into the CITY table contains CITY column value "'A Corua (La Corua)" which should be "A Coruña (La Coruña)".

How to repeat:
Download https://cdn.mysql.com/Downloads/MySQLInstaller/mysql-examples-8.0.28.msi (MySQL installer downloads this file if you mark "Samples and Examples" option to be installed). Inpack the file sakila_data.sql and view it. For to ensure that this is not viewer problem and the file is damagerd really you mayy look at the file content in hexadecimal regime.

# hexdump -C sakila-data.sql | grep  'A Coru'

is a simple way to see that the tilda-n is missing.

Thanks, Владислав (Vladislav). I was just coming here tonight to post this Sakila encoding bug that I myself discovered on April 6 and shared publicly on Stack Exchange on April 7. I guess you saw that post of mine (link below) and took the initiative to file a bug report. Team effort! No worries.

https://dba.stackexchange.com/questions/310675/where-can-we-find-a-copy-of-the-sakila-toy-...

Hello Владислав Сокол!

Thank you for the report and feedback.

regards,
Umesh

Posted by developer:
 
Thank you for the report, bug confirmed. 

It _appears_ it's always been this way whereas the world database contains correct values. I'm looking into ways to sync the two, and will look closer after the pending 8.0.29 release.

Related, the MSI contains an old copy of the world database with incorrect values but world/world_x have since been fixed so the MSI also needs an update.

Posted by developer:
 
An update: while this is fixed, the MSI hasn't caught up yet. I'm unsure when it will but Sakila 1.3 is available online and here's the changelog:

https://dev.mysql.com/doc/sakila/en/sakila-news.html#sakila-news-1-3

Sorry for the long delay. The broken country and city names were copied over from the World database.

Posted by developer:
 
Confirmed that the upcoming Installer release (for the upcoming MySQL 8.0.31 release) contains the fixed Sakila database.

Closing this bug report, thanks for reporting it!