ok, so my file_storage
tables as 8 field with the bad encoding
+--------------+--------------+-------------+--------------------+--------------------+
| table_schema | table_name | column_name | character_set_name | collation_name |
+--------------+--------------+-------------+--------------------+--------------------+
| passbolt | file_storage | user_id | utf8mb4 | utf8mb4_general_ci |
| passbolt | file_storage | foreign_key | utf8mb4 | utf8mb4_general_ci |
| passbolt | file_storage | model | utf8mb4 | utf8mb4_general_ci |
| passbolt | file_storage | filename | utf8mb4 | utf8mb4_general_ci |
| passbolt | file_storage | extension | utf8mb4 | utf8mb4_general_ci |
| passbolt | file_storage | hash | utf8mb4 | utf8mb4_general_ci |
| passbolt | file_storage | path | utf8mb4 | utf8mb4_general_ci |
| passbolt | file_storage | adapter | utf8mb4 | utf8mb4_general_ci |
+--------------+--------------+-------------+--------------------+--------------------+
8 rows in set (0.01 sec)
I will dit the change to utf8mb4_unicode_ci
.
Edit:
So I did it and it’s working
Thanks @remi
For people will facing the same trouble theses lines do the change
ALTER TABLE file_storage MODIFY user_id varchar(36) COLLATE utf8mb4_unicode_ci;
ALTER TABLE file_storage MODIFY foreign_key varchar(36) COLLATE utf8mb4_unicode_ci;
ALTER TABLE file_storage MODIFY model varchar(128) COLLATE utf8mb4_unicode_ci;
ALTER TABLE file_storage MODIFY filename varchar(255) COLLATE utf8mb4_unicode_ci;
ALTER TABLE file_storage MODIFY extension varchar(5) COLLATE utf8mb4_unicode_ci;
ALTER TABLE file_storage MODIFY hash varchar(64) COLLATE utf8mb4_unicode_ci;
ALTER TABLE file_storage MODIFY path varchar(255) COLLATE utf8mb4_unicode_ci;
ALTER TABLE file_storage MODIFY adapter varchar(32) COLLATE utf8mb4_unicode_ci;