Identifiers are stored in
db, and so
utf8, but identifiers can
contain only characters in the Basic Multilingual Plane (BMP).
Supplementary characters are not permitted in identifiers.
ucs2 character sets has the following
It cannot be used as a client character set, which means
that it does not work for
SET NAMES or
SET CHARACTER SET. (See
Section 10.1.4, “Connection Character Sets and Collations”.)
It is currently not possible to use
INFILE to load data files that use this
FULLTEXT indexes cannot be created on a
column that this character set. However, you can perform
IN BOOLEAN MODE searches on the column
without an index.
operators work in byte-wise fashion, so they are not multibyte
safe and may produce unexpected results with multibyte
character sets. In addition, these operators compare
characters by their byte values and accented characters may
not compare as equal even if a given collation treats them as