其他
字符集
支持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连接到瀚高数据库。
该参数值重启数据库生效。