其他

字符集

支持MySQL的以下字符集。

字符集
ascii
big5
binary
cp1250
cp1251
cp1256
cp1257
cp866
cp932
eucjpms
euckr
gb18030
gb2312
gbk
greek
hebrew
koi8r
koi8u
latin1
latin2
latin5
latin7
sjis
ujis
utf8
utf8mb3
utf8mb4

排序规则

字符集默认排序规则:

ascii_general_ci
big5_chinese_ci
binary
cp1250_general_ci
cp1251_general_ci
cp1256_general_ci
cp1257_general_ci
cp866_general_ci
cp932_japanese_ci
eucjpms_japanese_ci
euckr_korean_ci
gb18030_chinese_ci
gbk_chinese_ci
greek_general_ci
hebrew_general_ci
koi8r_general_ci
koi8u_general_ci
latin1_swedish_ci
latin2_general_ci
latin5_turkish_ci
latin7_general_ci
sjis_japanese_ci
ujis_japanese_ci
utf8_general_ci
utf8mb3_general_ci
utf8mb4_general_ci

中文语境排序规则:

gb2312_chinese_ci
gb2312_bin
gbk_chinese_ci
gbk_bin
gb18030_chinese_ci
gb18030_bin
gb18030_unicode_520_ci
utf8_general_ci
utf8_bin
utf8_unicode_ci
utf8_tolower_ci
utf8_general_mysql500_ci
utf8mb4_general_ci
utf8mb4_bin
utf8mb4_unicode_ci

协议

从V9.0.5开始支持兼容MySQL协议。

新增mysql.protocol_type参数,取值范围 :mysql、pg,默认为mysql。通过端口mysql.port(默认为3306)连接。

  • 当值为mysql时,允许用户从兼容MySQL协议工具连接到瀚高数据库;

  • 当值为pg时,允许用户从psql连接到瀚高数据库。

    该参数值重启数据库生效。