Path with emojis don't work when using Bulk Content Importer

[dudayz]

Dear Support,

I get error when bulk import SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,COERCIBLE) for operation '='

Then import won't running, I try to change collation in mysql database and table become utf8mb4_unicode_ci but still getting error, i attach u log for import.

Regards

 

[Rodolfo]

Sorry for the late reply.

Describe better the context for this issue.

 

[dudayz]

Hello, This issue happened on 3.18 but i think will happened too in 3.20.1

Bulk import stopped work if images has name with emoji icon, i attach screenshot for log, the file name for images is

صيدلية-النخلتين-Pharmaton-‍♂️‍♀️-🤷‍♀️ا.jpg

This filename cause stopped bulk import process, after deleted it import process continue to work. And also please check this too https://chevereto.com/community/thr...o-existing-users-use-bulk-import-method.13403 cause this is related topic according to bulk import feature.

 

[Rodolfo]

The importing table runs in UTF8, it doesn't support UTFMB4 at this time.

 

[dudayz]

The importing table runs in UTF8, it doesn't support UTFMB4 at this time.

I have change collation to utf8_general_ci and also try utf8_unicode_ci when import still get error I'm attach for error log

 

[Rodolfo]

This has been just implemented, now the bulk importer will take UTF8MB4 so it will support emoji and any other character in that set (including all 4-byte based lang characters).

The patch will be available in the next revision (3.20.2)