14.2.5.3. 2-Byte Collation IDs for InnoDB Tables

InnoDB tables can now use collation IDs greater than 255. Currently, the collation IDs in this range are all user-defined. For example, the following InnoDB table can now be created, where formerly the collation ID of 359 was beyond the range supported by InnoDB.

sql> show collation like 'ucs2_vn_ci';+------------+---------+-----+---------+----------+---------+| Collation  | Charset | Id  | Default | Compiled | Sortlen |+------------+---------+-----+---------+----------+---------+| ucs2_vn_ci | ucs2    | 359 |         |          |       8 |+------------+---------+-----+---------+----------+---------+1 row in set (0.00 sec)mysql> create table two_byte_collation (c1 char(1) character set ucs2 collate ucs2_vn_ci)  -> engine = InnoDB;Query OK, 0 rows affected (0.16 sec)