MySQL Bugs: #109631: Wrong collate in table details

Bug #109631	Wrong collate in table details
Submitted:	13 Jan 2023 21:05	Modified:	16 Jan 2023 12:25
Reporter:	Fábio Carpi	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S3 (Non-critical)
Version:	8.0.31	OS:	Windows (Microsoft Windows 11 Pro)
Assigned to:		CPU Architecture:	Other (x64)
Tags:	WBBugReporter

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
A table are created by sql query with collation utf8mb4_unicode_ci, but when i open the 'alter table' window, the collation shows as utf8mb4_0900_ai_ci

How to repeat:
create table test(test varchar(1) not null) default charset=utf8mb4 collate=utf8mb4_unicode_ci

Hello Fábio,

Thank you for the bug report.
Imho this is duplicate of Bug #92534, please see Bug #92534.

Regards,
Ashwini Patil