Bug #97726 Collator utf8mb4_0900_bin is missing
Submitted: 21 Nov 2019 9:43 Modified: 22 Nov 2019 9:39
Reporter: Björn Michael (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.18 OS:Windows
Assigned to: CPU Architecture:Any

[21 Nov 2019 9:43] Björn Michael
Description:
At every location where collators can be selected in pull down menu the new 'utf8mb4_0900_bin' collator is missing.

* utf8mb4_0900_ai_ci
* utf8mb4_0900_as_ci
* utf8mb4_0900_as_cs
* utf8mb4_bin
* ...

Obviously 'utf8mb4_0900_bin' is missing although it was introduced with MySQL 8.0.17

How to repeat:
Edit schema or table definition in MySQL workbench a choose drop down for collators.

Suggested fix:
Add entry 'utf8mb4_0900_bin' or fetch all supported collators from MySQL server.
[22 Nov 2019 9:39] MySQL Verification Team
Hello Björn Michael,

Thank you for the bug report.
Verified as described.

Regards,
Ashwini Patil
[22 Nov 2019 9:44] MySQL Verification Team
8.0.18 test results

Attachment: 97726_results.docx (application/vnd.openxmlformats-officedocument.wordprocessingml.document, text), 194.04 KiB.