大海上大
#1
【产品名称】OceanBase DataBase
【产品版本】3.1.2 CE
【问题描述】创建表时指定字段编码方式为utf32,创建失败
建表语句如下:
DROP TABLE IF EXISTS `test_utf32`; CREATE TABLE `test_utf32` ( `id` varchar(64) CHARACTER SET utf32 COLLATE utf32_general_ci NOT NULL COMMENT ‘测试uft32’, PRIMARY KEY (`id`) )ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
和顺
#2
目前社区版OB支持的字符集和校验字符集如下:
mysql> show charset;
+---------+-----------------------+--------------------+--------+
| Charset | Description | Default collation | Maxlen |
+---------+-----------------------+--------------------+--------+
| binary | Binary pseudo charset | binary | 1 |
| utf8mb4 | UTF-8 Unicode | utf8mb4_general_ci | 4 |
+---------+-----------------------+--------------------+--------+
2 rows in set (0.01 sec)
说明一下,在OB里utf8和utf8mb4是同义词。
longda
#3
utf32 已经排在计划里面, 计划4.x 会发出来, 要是方便留下公司的名字, 我们可以把优先级往上排