Bug #99196 Unable to update MySQL content with Excel
Submitted: 7 Apr 2020 2:09 Modified: 7 Apr 2020 5:01
Reporter: An Nguyen Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL for Windows: MySQL for Excel Severity:S2 (Serious)
Version:1.3.8 OS:Windows (Windows 10)
Assigned to: CPU Architecture:Any
Tags: MySQL for Excel, Windows 10

[7 Apr 2020 2:09] An Nguyen 
Description:
Error report:

"MySQL Error 1267:
Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '='"

How to repeat:

1. Connect MySQL via MySQL for Excel \ Edit MySQL Data
2. Edit any cell in sheet
3. Commit changes
[7 Apr 2020 2:14] An Nguyen 
Screenshot

Attachment: Untitled.png (image/png, text), 93.81 KiB.
[7 Apr 2020 5:01] MySQL Verification Team 
Hello An Nguyen,

Thank you for the report and feedback.
Imho this is duplicate of Bug #96119, please see Bug #96119
Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

regards,
Umesh