MySQL 8.2 Release Notes
For MaxDB compatibility these two statements are the same:
CREATE TABLE t1 (f1 CHAR(N) UNICODE); CREATE TABLE t1 (f1 CHAR(N) CHARACTER SET ucs2);
UNICODE attribute and the
ucs2 character set are deprecated; you should
expect them to be removed in a future version of MySQL.