MySQL:带有UTF字符的表名

Question

我很难用 UTF 字符在 MySQL 中创建表。我完全不知道如何解决这个问题。

在这个特定的表名中只有两个特殊字符:

• 1F4D2 📒 分类帐 ( http://www.unicode.org/charts/PDF/U1F300.pdf )
• 274E ❎ 负平方十字标记 ( http://www.unicode.org/charts/PDF/U2700.pdf )

代码:

CREATE TABLE `📒_❎` (id INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT);

留言:

Invalid utf8 character string: '📒_❎'

然而，这有效:

SELECT _utf8'📒_❎'

Answer 1

看看下面的页面: http://dev.mysql.com/doc/refman/5.1/en/identifiers.html

有问题的字符是 1F4D2，如文档所述:

Permitted characters in quoted identifiers include the full Unicode Basic Multilingual Plane (BMP), except U+0000:

ASCII: U+0001 .. U+007F

Extended: U+0080 .. U+FFFF

ASCII NUL (U+0000) and supplementary characters (U+10000 and higher) are not permitted in quoted or unquoted identifiers.