[install/migration] MySQL Greek characters in migration script 18.0.0-19.0.0.sql causing errors

[Benvii]

Bug

I everyone running the migration from 18.0.* to 19.0.2 I've got the following error :

Request 62 sql='ALTER TABLE llx_c_invoice_subtype MODIFY COLUMN code varchar(5) NOT NULL;'
Request 63 sql='insert into llx_c_invoice_subtype (entity, fk_country, code, label, active) VALUES (1, 102, '5.1', 'Πιστωτικό Τιμολόγιο / Συσχετιζόμενο', 0);'
Erreur DB_ERROR_1366 (Req 63): insert into llx_c_invoice_subtype (entity, fk_country, code, label, active) VALUES (1, 102, '5.1', 'Πιστωτικό Τιμολόγιο / Συσχετιζόμενο', 0);
Incorrect string value: '\xCE\xA0\xCE\xB9\xCF\x83...' for column 'label' at row 1
Request 64 sql='insert into llx_c_invoice_subtype (entity, fk_country, code, label, active) VALUES (1, 102, '5.2', 'Πιστωτικό Τιμολόγιο / Μη Συσχετιζόμενο', 1);'
Erreur DB_ERROR_1366 (Req 64): insert into llx_c_invoice_subtype (entity, fk_country, code, label, active) VALUES (1, 102, '5.2', 'Πιστωτικό Τιμολόγιο / Μη Συσχετιζόμενο', 1);
Incorrect string value: '\xCE\xA0\xCE\xB9\xCF\x83...' for column 'label' at row 1
Request 65 sql='insert into llx_c_invoice_subtype (entity, fk_country, code, label, active) VALUES (1, 102, '11.4', 'Πιστωτικό Στοιχ. Λιανικής', 1);'
Erreur DB_ERROR_1366 (Req 65): insert into llx_c_invoice_subtype (entity, fk_country, code, label, active) VALUES (1, 102, '11.4', 'Πιστωτικό Στοιχ. Λιανικής', 1);
Incorrect string value: '\xCE\xA0\xCE\xB9\xCF\x83...' for column 'label' at row 1
Request 66 sql='ALTER TABLE llx_product ADD COLUMN stockable_product integer DEFAULT 1 NOT NULL;'

This table is in latin1_swedish_ci on my installation, upgrade seems to work fine even with this error. As it may impact other users I prefer to open this issue.

It was introduced here : 1e3e53f

Dolibarr Version

19.0.2

Environment PHP

7.4

Environment Database

Mysql (5.7)

Steps to reproduce the behavior and expected behavior

Run a migration from 18.0.* or 19.0.0 -> 19.0.* on MySQL database.

Attached files

[ksar-ksar]

Hello,

All your database tables should be in uft8_general_ci

[Benvii]

Thanks for your reply I've altered all tables to be in uft8_general_ci and migration passed successfully.

[arusa]

JFI: for me the solution was:

ALTER TABLE llx_c_invoice_subtype COLLATE utf8_general_ci;
ALTER TABLE llx_c_invoice_subtype MODIFY label varchar(100) CHARACTER SET utf8 DEFAULT NULL;