# 数据类型兼容列表
本章节介绍数据加密系统插件（Application-Plugin）模式与代理（Proxy）模式√的数据类型**。**
#### MySQL
| 字段类型             | 加密   | 解密   | 完整性 | sdk新增入库密文 | sdk查询展示明文+脱敏 | sdk编辑 | sdk模糊查询 | 代理新增入库密文 | 代理查询展示明文+脱敏 | 代理编辑 | 代理模糊查询 |
|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|
| varchar           | √  | √ | √   | √     | √          | √    | √      | √    | √           | √       | √    |
| char               | √    | √ | √ | √      | √        | √    | √      | √      | √            | √     | √   |
| tinytext        | ×    | ×   | ×   | ×         | ×           | ×       | ×      | ×      | ×           | ×       | ×   |
| text              | √  | √  | √    | √      | √         | √      | √       | √       | √           | √      | √     |
| mediumtext         | ×    | ×    | ×  | ×         | ×          | ×      | ×      | ×        | ×          | ×     | ×     |
| longtext           | ×  | ×  | ×   | ×         | ×           | ×    | ×     | ×        | ×             | ×     | ×       |
| json             | ×    | ×    | ×    | ×      | ×          | ×    | ×       | ×      | ×           | ×      | ×   |
| decimal         | ×   | ×  | ×    | ×       | ×            | ×     | ×      | ×       | ×          | ×      | ×      |
| double            | ×  | ×  | ×    | ×         | ×          | ×   | ×       | ×       | ×            | ×       | ×   |
| float             | × | ×  | ×     | ×       | ×            | ×    | ×      | ×      | ×           | ×       | ×    |
| int             | ×   | ×   | ×   | ×       | ×            | ×     | ×        | ×       | ×            | ×       | ×      |
| int unsigned    | ×   | ×   | ×    | ×         | ×          | ×     | ×         | ×        | ×           | ×        | ×      |
| integer            | ×  | ×     | ×  | ×      | ×             | ×      | ×       | ×      | ×           | ×      | ×     |
| integer unsigned   | ×   | ×    | ×   | ×          | ×           | ×      | ×      | ×       | ×             | ×       | ×    |
| bigint             | ×  | ×  | ×  | ×         | ×             | ×      | ×        | ×         | ×          | ×       | ×     |
| bigint unsigned | × | ×  | ×    | ×        | ×          | ×     | ×      | ×      | ×          | ×     | ×      |
| smallint           | × | ×  | ×    | ×         | ×           | ×       | ×        | ×       | ×           | ×       | ×     |
| smallint unsigned | ×    | ×    | ×    | ×       | ×         | ×    | ×      | ×       | ×          | ×       | ×   |
| bit              | ×    | × | ×   | ×        | ×          | ×    | ×        | ×      | ×            | ×     | ×       |
| binary             | ×   | ×    | ×   | ×       | ×         | ×   | ×       | ×      | ×          | ×       | ×      |
| varbinary          | ×   | ×    | ×   | ×        | ×          | ×      | ×     | ×        | ×           | ×     | ×       |
| tinyblob          | ×   | ×  | ×  | ×        | ×           | ×     | ×        | ×        | ×          | ×      | ×    |
| blob             | ×    | ×   | ×   | ×       | ×           | ×     | ×      | ×       | ×           | ×      | ×   |
| mediumblob         | ×    | ×    | ×    | ×        | ×            | ×     | ×        | ×       | ×            | ×      | ×     |
| longblob          | ×   | × | ×  | ×        | ×           | ×     | ×         | ×       | ×         | ×     | ×      |
   
![](https://support.huaweicloud.com/usermanual-dbss/public_sys-resources/note_3.0-zh-cn.png)
主键不支持配置密钥，也不支持加密。
#### MariaDB
| 字段类型             | 加密   | 解密 | 完整性 | sdk新增入库密文 | sdk查询展示明文+脱敏 | sdk编辑 | sdk模糊查询 | 代理新增入库密文 | 代理查询展示明文+脱敏 | 代理编辑 | 代理模糊查询 |
|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|
| varchar          | √   | √    | √    | √         | √            | √       | √        | √         | √           | √     | √       |
| char           | √     | √   | √   | √        | √           | √       | √          | √       | √           | √  | √       |
| tinytext         | ×  | ×      | ×  | ×           | ×               | ×        | ×          | ×          | ×              | ×     | ×        |
| text             | √    | √   | √   | √        | √              | √         | √      | √        | √           | √    | √        |
| mediumtext        | ×    | ×    | ×    | ×          | ×             | ×      | ×        | ×       | ×              | ×   | ×         |
| longtext        | ×   | ×   | ×  | ×         | ×              | ×        | ×        | ×      | ×           | ×   | ×        |
| json             | × | ×   | ×    | ×         | ×             | ×        | ×      | ×       | ×             | ×  | ×       |
| decimal           | ×    | ×   | ×  | ×       | ×             | ×      | ×       | ×      | ×           | ×    | ×         |
| double            | ×   | ×   | ×  | ×         | ×            | ×      | ×         | ×       | ×            | ×    | ×       |
| float           | ×   | ×    | ×   | ×        | ×             | ×       | ×         | ×        | ×            | ×   | ×       |
| int              | ×  | ×    | ×   | ×         | ×             | ×        | ×        | ×      | ×              | ×  | ×        |
| int unsigned     | ×  | ×    | ×  | ×          | ×            | ×      | ×       | ×        | ×             | ×    | ×       |
| integer         | ×    | ×  | ×  | ×       | ×             | ×       | ×        | ×       | ×            | ×    | ×        |
| integer unsigned | ×    | ×   | ×   | ×         | ×             | ×      | ×       | ×        | ×              | ×   | ×       |
| bigint            | ×  | ×    | ×  | ×        | ×             | ×      | ×        | ×       | ×          | ×    | ×        |
| bigint unsigned  | ×    | ×      | ×   | ×        | ×           | ×         | ×       | ×        | ×             | ×   | ×       |
| smallint         | ×  | ×     | ×  | ×        | ×              | ×       | ×      | ×      | ×           | ×     | ×         |
| smallint unsigned | ×  | ×     | ×   | ×       | ×             | ×      | ×        | ×       | ×           | ×   | ×        |
| bit             | ×    | ×     | ×   | ×       | ×            | ×        | ×      | ×       | ×             | ×  | ×          |
| binary            | ×  | ×   | ×  | ×         | ×            | ×      | ×         | ×       | ×              | ×  | ×         |
| varbinary        | ×  | ×    | ×    | ×         | ×            | ×     | ×        | ×       | ×            | ×  | ×       |
| tinyblob         | ×   | ×    | ×  | ×          | ×            | ×        | ×        | ×      | ×             | ×  | ×      |
| blob            | × | ×     | ×   | ×        | ×            | ×      | ×       | ×        | ×            | ×   | ×       |
| mediumblob       | ×    | ×     | ×   | ×         | ×              | ×        | ×        | ×     | ×             | × | ×         |
| longblob         | ×   | ×    | ×  | ×         | ×            | ×       | ×        | ×     | ×            | ×  | ×        |
   
![](https://support.huaweicloud.com/usermanual-dbss/public_sys-resources/note_3.0-zh-cn.png)
主键不支持配置密钥，也不支持加密。
#### Oracle
| 字段类型      | 加密 | 解密 | 完整性 | sdk新增入库密文 | sdk查询展示明文+脱敏 | sdk编辑 | sdk模糊查询 |
|:---|:---|:---|:---|:---|:---|:---|:---|
| CHAR      | √   | √   | ×    | √          | √             | √      | √       |
| VARCHAR | √ | √    | ×  | √        | √           | √     | √         |
| NCHAR     | × | ×   | ×   | ×         | ×             | ×    | ×         |
| VARCHAR2 | √    | √    | ×    | √          | √            | √    | √         |
| NVARCHAR2 | ×   | ×   | ×     | ×         | ×             | ×     | ×          |
| CLOB      | ×   | ×     | ×   | ×         | ×             | ×     | ×      |
| NCLOB    | ×   | ×    | ×     | ×          | ×          | ×     | ×         |
| LONG      | ×  | ×    | ×    | ×          | ×            | ×     | ×       |
| NUMBER   | ×  | ×     | ×   | ×         | ×           | ×     | ×        |
| FLOAT     | ×  | ×    | ×    | ×        | ×            | ×     | ×        |
   
![](https://support.huaweicloud.com/usermanual-dbss/public_sys-resources/note_3.0-zh-cn.png)
- 不需要设置逻辑主键就可以加解密。
- CLOB、NCLOB类型，在插件中查询数据可以解密，如果查询条件中带CLOB、NCLOB类型只能Like，其他方式不支持。
 
#### MS SQL Server
| 字段类型               | 加密 | 解密  | 完整性 | sdk新增入库密文 | sdk查询展示明文+脱敏 | sdk编辑 | sdk模糊查询 | 代理新增入库密文 | 代理查询展示明文+脱敏 | 代理编辑 | 代理模糊查询 |
|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|
| bigint            | ×   | ×   | ×     | ×        | ×               | ×     | ×       | ×      | ×           | × | ×     |
| binary           | ×    | × | ×    | ×        | ×             | ×      | ×       | ×      | ×           | ×  | ×      |
| char             | √  | √ | √    | √        | √               | √     | √        | √       | √           | √ | √      |
| int              | ×  | ×  | ×     | ×          | ×             | ×    | ×          | ×     | ×            | ×   | ×       |
| varchar         | √   | √    | √  | √        | √            | √     | √       | √       | √           | √   | √     |
| text（varchar-max） | √   | √ | √    | √          | √            | √    | √         | √      | √           | √  | √      |
| nchar            | ×    | ×     | ×    | ×       | ×           | ×     | ×       | ×        | ×           | ×   | ×      |
| nvarchar         | ×     | × | ×     | ×        | ×             | ×    | ×        | ×       | ×          | × | ×       |
| nvarchar（max）    | ×   | ×  | ×   | ×         | ×              | ×     | ×       | ×       | ×         | ×  | ×       |
| decimal         | ×  | × | ×    | ×        | ×              | ×     | ×         | ×        | ×         | ×   | ×      |
| float            | ×  | × | ×    | ×        | ×             | ×      | ×        | ×       | ×           | ×  | ×     |
| image             | ×     | ×  | ×    | ×      | ×            | ×      | ×       | ×        | ×         | ×    | ×      |
| money            | ×   | ×   | ×     | ×         | ×              | ×     | ×        | ×         | ×         | ×  | ×       |
| nchar          | ×   | ×    | ×    | ×        | ×           | ×     | ×         | ×      | ×          | ×   | ×        |
| ntext             | ×   | ×  | ×    | ×       | ×            | ×    | ×        | ×        | ×         | ×    | ×     |
| numeric          | ×    | ×   | ×       | ×         | ×               | ×      | ×           | ×       | ×            | ×   | ×       |
| nvarchar        | ×    | ×    | ×    | ×        | ×             | ×     | ×         | ×         | ×            | ×   | ×     |
| nvarchar（max）   | ×     | ×   | ×     | ×         | ×             | ×     | ×        | ×         | ×            | ×    | ×       |
| varbinary        | ×    | ×  | ×   | ×        | ×             | ×     | ×         | ×       | ×          | ×    | ×       |
| varbinary（max）    | ×      | ×   | ×      | ×          | ×               | ×       | ×        | ×       | ×          | ×     | ×        |
| varchar（max）      | ×   | ×   | ×       | ×        | ×              | ×      | ×         | ×      | ×          | ×     | ×       |
| real             | ×   | ×   | ×     | ×        | ×               | ×      | ×         | ×       | ×           | ×   | ×       |
| smallint        | ×   | ×   | ×    | ×         | ×             | ×       | ×         | ×       | ×           | ×  | ×        |
| smallmoney       | ×    | ×   | ×      | ×         | ×              | ×       | ×        | ×       | ×         | ×     | ×       |
| tinyint          | ×  | ×    | ×    | ×           | ×               | ×        | ×          | ×         | ×            | ×     | ×      |
| datetime         | ×     | ×    | ×      | ×          | ×              | ×     | ×         | ×         | ×           | ×    | ×      |
| int identity     | ×    | ×    | ×    | ×         | ×             | ×     | ×          | ×         | ×           | ×   | ×     |
| xml              | ×    | × | ×      | ×         | ×            | ×       | ×           | ×        | ×            | ×   | ×       |
   
![](https://support.huaweicloud.com/usermanual-dbss/public_sys-resources/note_3.0-zh-cn.png)
- 勾选字段保存成逻辑主键后可支持加密和解密。
- SQL Server主键、索引不支持加密，不支持设置密钥。
 
#### PostgresSQL
| 字段类型              | 加密    | 解密 | 完整性 | sdk新增入库密文 | sdk查询展示明文+脱敏 | sdk编辑 | sdk模糊查询 | 代理新增入库密文 | 代理查询展示明文+脱敏 | 代理编辑 | 代理模糊查询 |
|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|
| smallint          | ×   | ×   | × | ×         | ×             | ×    | ×         | ×       | ×         | ×      | ×      |
| integer             | ×  | ×    | ×     | ×        | ×            | ×    | ×        | ×          | ×            | ×        | ×    |
| int2                | ×  | ×    | × | ×       | ×             | ×    | ×        | ×          | ×             | ×    | ×     |
| int4              | ×  | × | ×  | ×       | ×              | ×    | ×         | ×          | ×            | ×      | ×      |
| int8              | ×  | ×   | ×   | ×         | ×              | ×   | ×       | ×        | ×            | ×       | ×    |
| bigint             | ×    | ×    | ×    | ×       | ×             | ×    | ×       | ×          | ×         | ×      | ×    |
| decimal             | ×    | ×  | ×    | ×       | ×            | ×    | ×        | ×         | ×           | ×       | ×    |
| numeric           | ×  | ×   | ×  | ×         | ×             | ×   | ×        | ×         | ×            | ×       | ×     |
| real               | ×  | ×  | ×    | ×        | ×             | ×    | ×       | ×          | ×            | ×       | ×     |
| float4             | ×  | ×    | ×  | ×        | ×            | ×    | ×         | ×         | ×             | ×        | ×      |
| double precision   | ×   | ×   | ×   | ×       | ×             | ×     | ×       | ×           | ×          | ×     | ×    |
| float8             | ×   | ×  | ×   | ×        | ×             | ×   | ×         | ×         | ×           | ×       | ×     |
| varchar             | √   | √   | √      | √          | √              | √     | √        | √         | √            | √       | √     |
| char             | √   | √   | √    | √          | √            | √      | √       | √           | √           | √        | √      |
| bpchar              | ×   | ×  | ×    | ×       | ×            | ×    | ×       | ×        | ×             | ×       | ×       |
| character         | × | ×   | ×    | ×       | ×            | ×   | ×       | ×         | ×         | ×      | ×     |
| character varying | ×  | ×   | × | ×         | ×            | ×    | ×       | ×         | ×           | ×       | ×      |
| text                 | √   | √   | √   | √        | √              | √     | √         | √          | √           | √        | √      |
| bytea              | ×  | × | ×   | ×         | ×            | ×     | ×       | ×         | ×           | ×      | ×      |
   
#### Greemplum
| 字段类型              | 加密    | 解密  | 完整性 | sdk新增入库密文 | sdk查询展示明文+脱敏 | sdk编辑 | sdk模糊查询 | 代理新增入库密文 | 代理查询展示明文+脱敏 | 代理编辑 | 代理模糊查询 |
|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|
| varchar            | √   | √    | √   | ×       | ×          | ×   | ×         | √       | √           | √        | √       |
| char             | √  | √     | √  | ×       | ×          | ×    | ×       | √     | √            | √     | ×       |
| tinytext             | ×      | ×     | ×    | ×       | ×             | ×    | ×         | ×      | ×             | ×        | ×        |
| text             | √  | √   | √   | ×     | ×           | ×    | ×        | √       | √           | √      | √      |
| mediumtext         | ×   | ×  | ×   | ×       | ×            | ×    | ×         | ×       | ×            | ×       | ×        |
| longtext           | ×   | ×    | ×   | ×      | ×          | ×   | ×        | ×    | ×            | ×      | ×       |
| json                 | ×   | ×    | ×  | ×         | ×            | ×   | ×        | ×       | ×           | ×      | ×      |
| decimal             | ×    | ×   | ×  | ×         | ×            | ×     | ×         | ×      | ×             | ×     | ×      |
| double             | × | ×    | ×   | ×        | ×            | ×    | ×        | ×        | ×             | ×      | ×     |
| float             | ×  | ×     | ×     | ×       | ×           | ×    | ×       | ×       | ×             | ×      | ×      |
| int                | ×   | ×    | ×   | ×       | ×           | ×   | ×        | ×     | ×             | ×       | ×    |
| int unsigned         | × | ×      | ×     | ×       | ×           | ×    | ×         | ×     | ×             | ×      | ×     |
| integer           | ×     | ×  | ×  | ×        | ×          | ×    | ×         | ×      | ×              | ×      | ×        |
| integer unsigned  | ×   | ×   | ×    | ×         | ×           | ×   | ×      | ×      | ×           | ×       | ×     |
| bigint            | ×    | ×   | ×   | ×     | ×         | ×    | ×        | ×     | ×            | ×     | ×     |
| bigint unsigned     | ×    | ×   | ×  | ×        | ×          | ×    | ×      | ×       | ×           | ×     | ×      |
| smallint          | × | ×  | × | ×         | ×           | ×     | ×       | ×     | ×           | ×    | ×      |
| smallint unsigned | ×    | ×    | ×     | ×         | ×           | ×      | ×        | ×     | ×             | ×      | ×       |
| bit                | × | ×   | ×  | ×       | ×            | ×   | ×        | ×      | ×            | ×      | ×     |
| binary            | × | × | ×  | ×        | ×          | ×   | ×       | ×       | ×            | ×      | ×       |
| varbinary          | ×    | × | ×  | ×        | ×            | ×   | ×        | ×      | ×              | ×     | ×       |
| tinyblob            | ×  | ×   | ×    | ×       | ×             | ×      | ×       | ×       | ×           | ×      | ×       |
| blob               | ×  | ×     | ×   | ×        | ×            | ×    | ×        | ×      | ×             | ×      | ×    |
| mediumblob        | ×   | ×   | ×  | ×      | ×            | ×     | ×       | ×       | ×           | ×      | ×     |
| longblob           | ×    | × | ×   | ×      | ×         | ×     | ×      | ×      | ×             | ×     | ×       |
   
![](https://support.huaweicloud.com/usermanual-dbss/public_sys-resources/note_3.0-zh-cn.png)
- 主键不支持配置密钥，也不支持加密。
- char和bpchar字段不支持模糊匹配。
 
#### 达梦
| 字段类型              | 加密  | 解密 | 完整性 | sdk新增入库密文 | sdk查询展示明文+脱敏 | sdk编辑 | sdk模糊查询 | 代理新增入库密文 | 代理查询展示明文+脱敏 | 代理编辑 | 代理模糊查询 |
|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|
| varchar           | √ | √  | √     | √           | √              | √      | √     | √      | √            | √    | ×       |
| char             | √ | √   | √    | √         | √            | √      | √     | √      | √            | √   | ×     |
| tinytext          | ×  | ×  | ×   | ×         | ×              | ×       | ×     | ×      | ×           | ×    | ×      |
| text              | √   | √    | √    | √          | √            | √      | √    | √      | √             | √     | ×      |
| mediumtext       | ×  | × | ×     | ×           | ×            | ×      | ×     | ×      | ×            | ×    | ×      |
| longtext          | ×  | ×   | ×    | ×         | ×            | ×    | ×     | ×     | ×            | ×    | ×      |
| json             | × | ×   | ×   | ×        | ×            | ×      | ×      | ×        | ×           | ×      | ×        |
| decimal         | ×   | ×    | ×    | ×        | ×           | ×     | ×       | ×        | ×           | ×    | ×        |
| double            | ×   | ×   | ×   | ×          | ×            | ×       | ×      | ×        | ×            | ×    | ×       |
| float              | ×   | ×  | ×     | ×          | ×           | ×      | ×        | ×      | ×             | ×     | ×       |
| int              | × | ×  | ×    | ×         | ×             | ×      | ×      | ×        | ×              | ×    | ×        |
| int unsigned      | × | ×   | ×   | ×         | ×           | ×      | ×    | ×       | ×           | ×   | ×      |
| integer           | × | ×  | ×    | ×          | ×           | ×      | ×      | ×        | ×            | ×   | ×      |
| integer unsigned    | × | ×  | ×   | ×         | ×            | ×     | ×     | ×       | ×            | ×    | ×       |
| bigint            | ×   | ×   | ×     | ×          | ×             | ×       | ×     | ×      | ×          | ×    | ×      |
| bigint unsigned   | ×   | ×  | ×  | ×           | ×           | ×     | ×     | ×      | ×            | ×  | ×        |
| smallint          | ×  | ×  | ×    | ×          | ×           | ×     | ×    | ×        | ×            | ×     | ×        |
| smallint unsigned | × | ×  | ×     | ×         | ×             | ×     | ×      | ×     | ×           | ×    | ×      |
| bit              | × | ×     | ×     | ×        | ×             | ×       | ×      | ×      | ×             | ×    | ×      |
| binary            | ×  | ×   | ×   | ×         | ×           | ×       | ×      | ×       | ×             | ×    | ×      |
| varbinary          | ×  | ×   | ×    | ×         | ×           | ×      | ×    | ×        | ×            | ×   | ×       |
| tinyblob         | ×   | ×    | ×     | ×        | ×            | ×       | ×     | ×      | ×           | ×    | ×        |
| blob              | × | ×     | ×   | ×         | ×          | ×      | ×     | ×        | ×           | ×  | ×      |
| mediumblob        | ×  | ×   | ×     | ×          | ×             | ×      | ×      | ×        | ×            | ×   | ×       |
| longblob        | × | ×    | ×     | ×        | ×              | ×      | ×      | ×       | ×             | ×   | ×        |
   
![](https://support.huaweicloud.com/usermanual-dbss/public_sys-resources/note_3.0-zh-cn.png)
主键不支持配置密钥，也不支持加密。
#### DB2
| 字段类型              | 加密  | 解密 | 完整性 | sdk新增入库密文 | sdk查询展示明文+脱敏 | sdk编辑 | sdk模糊查询 | 代理新增入库密文 | 代理查询展示明文+脱敏 | 代理编辑 | 代理模糊查询 |
|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|
| varchar           | √   | √  | √   | √         | √            | √     | √       | √        | √           | √  | ×       |
| char                | √   | √    | √    | √         | √             | √    | √     | √       | √           | √  | ×      |
| tinytext            | × | ×  | ×  | ×          | ×           | ×   | ×      | ×       | ×         | ×  | ×     |
| text               | √   | √    | √    | ×        | ×            | ×     | ×       | ×      | ×            | ×  | ×      |
| mediumtext         | ×    | ×    | ×      | ×         | ×             | ×     | ×       | ×         | ×           | ×   | ×      |
| longtext           | ×    | ×  | ×    | ×          | ×            | ×     | ×      | ×        | ×           | ×   | ×      |
| json               | ×    | ×    | ×    | ×          | ×            | ×    | ×        | ×       | ×          | ×  | ×      |
| decimal             | ×   | ×     | ×   | ×         | ×             | ×      | ×       | ×         | ×            | × | ×      |
| double             | × | ×   | ×   | ×          | ×              | ×    | ×      | ×        | ×          | ×  | ×        |
| float              | ×   | ×    | ×   | ×          | ×             | ×       | ×      | ×       | ×           | ×   | ×       |
| int                 | ×   | ×    | ×    | ×           | ×             | ×   | ×        | ×       | ×            | ×  | ×         |
| int unsigned         | ×   | ×   | ×     | ×          | ×             | ×      | ×      | ×        | ×           | ×   | ×       |
| integer            | ×  | ×   | ×  | ×           | ×           | ×    | ×       | ×        | ×             | ×  | ×      |
| integer unsigned    | ×    | ×     | ×     | ×         | ×             | ×   | ×      | ×       | ×            | ×   | ×        |
| bigint            | ×    | ×      | ×   | ×          | ×          | ×    | ×         | ×          | ×           | ×  | ×        |
| bigint unsigned   | ×  | ×   | ×    | ×          | ×           | ×     | ×       | ×         | ×          | ×  | ×       |
| smallint          | ×   | ×    | ×     | ×           | ×            | ×    | ×       | ×        | ×           | ×   | ×        |
| smallint unsigned | ×  | ×    | ×   | ×          | ×            | ×     | ×      | ×       | ×           | ×   | ×       |
| bit                | ×    | ×   | ×     | ×           | ×            | ×      | ×       | ×        | ×           | ×   | ×      |
| binary            | ×  | ×   | ×     | ×          | ×            | ×     | ×        | ×       | ×          | ×   | ×       |
| varbinary          | × | ×     | ×  | ×          | ×            | ×    | ×        | ×      | ×          | ×    | ×        |
| tinyblob          | ×   | ×  | ×     | ×         | ×           | ×     | ×      | ×        | ×            | ×    | ×         |
| blob                | ×   | ×    | ×   | ×          | ×          | ×     | ×        | ×        | ×           | ×    | ×      |
| mediumblob         | ×    | ×  | ×   | ×           | ×            | ×      | ×        | ×        | ×           | × | ×      |
| longblob           | × | ×   | ×      | ×          | ×            | ×    | ×        | ×      | ×            | ×  | ×       |
   
![](https://support.huaweicloud.com/usermanual-dbss/public_sys-resources/note_3.0-zh-cn.png)
- 主键不支持配置密钥，也不支持加密。
- DB2没有text类型，char类型在DB2中是定长的，会自动补充空格，所以不支持模糊匹配。
 
#### 人大金仓（MySQL模式）
| 字段类型      | 加密 | 解密  | 完整性  | sdk新增入库密文 | sdk查询展示明文+脱敏 | sdk编辑 | sdk模糊查询 | 代理新增入库密文 | 代理查询展示明文+脱敏 | 代理编辑 | 代理模糊查询 |
|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|
| int2    | ×     | ×    | ×   | ×         | ×              | ×     | ×       | ×          | ×            | ×   | ×      |
| int4      | ×     | ×  | ×   | ×            | ×           | ×       | ×     | ×         | ×            | ×    | ×       |
| int8     | ×  | × | ×   | ×           | ×           | ×       | ×      | ×         | ×             | ×   | ×       |
| numeric  | ×   | ×  | ×  | ×           | ×           | ×      | ×       | ×        | ×            | ×   | ×     |
| real       | × | ×  | ×  | ×          | ×             | ×       | ×         | ×         | ×            | ×     | ×      |
| float4   | ×   | ×     | ×   | ×           | ×            | ×      | ×        | ×         | ×            | ×    | ×       |
| float8    | ×  | ×   | ×     | ×           | ×           | ×      | ×       | ×        | ×            | ×    | ×    |
| varchar | √   | √  | √   | √            | √           | √        | √        | √         | √           | √    | √      |
| char      | √  | √  | √  | √           | √            | √        | √       | √          | √             | √    | √      |
| bpchar   | ×  | ×    | ×   | ×          | ×            | ×    | ×        | ×        | ×            | ×    | ×     |
| text     | √   | ×   | √   | √          | √            | √     | √      | √         | √             | √   | √    |
| jsonb     | ×  | ×   | ×  | ×            | ×           | ×      | ×        | ×        | ×           | ×    | ×       |
| json       | √   | √   | √  | ×           | ×           | ×      | ×      | ×         | ×            | ×     | ×      |
| bytea     | ×  | ×     | ×  | ×           | ×          | ×       | ×        | ×         | ×              | ×    | ×       |
| blob      | ×   | ×   | × | ×           | ×           | ×      | ×      | ×          | ×            | ×   | ×       |
   
#### DWS_GAUSSDB
| 字段类型                | 加密  | 解密  | 完整性  | sdk新增入库密文 | sdk查询展示明文+脱敏              | sdk编辑  | sdk模糊查询 | 代理新增入库密文 | 代理查询展示明文+脱敏 | 代理编辑 | 代理模糊查询 |
|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|
| varchar               | √  | √   | √   | √       | select\*不支持，select具体字段支持 | √   | √     | √       | √         | √ | √    |
| char                | √ | √  | √ | √     | select\*不支持，select具体字段支持   | √  | √     | √         | √        | √  | × |
| tinytext            | × | ×  | ×   | ×       | ×                       | ×   | ×      | ×       | ×          | ×  | ×   |
| text                | √ | √   | √ | √      | select\*不支持，select具体字段支持 | √  | √       | √     | √         | √ | √   |
| mediumtext          | ×     | ×     | ×  | ×       | ×                          | ×    | ×      | ×          | ×           | ×     | ×    |
| longtext            | ×   | ×  | ×   | ×        | ×                           | ×    | ×      | ×         | ×          | ×      | ×    |
| json                | ×    | ×   | ×   | ×        | ×                          | ×   | ×       | ×         | ×            | ×    | ×    |
| decimal            | ×   | ×   | ×   | ×       | ×                        | ×   | ×      | ×        | ×             | ×   | ×     |
| double              | ×  | ×    | ×   | ×          | ×                         | ×   | ×        | ×         | ×           | ×    | ×    |
| float                | ×   | ×   | ×    | ×      | ×                        | ×  | ×      | ×         | ×         | ×   | ×  |
| int                 | ×    | ×    | ×  | ×        | ×                        | ×   | ×       | ×        | ×        | ×   | ×     |
| int unsigned        | ×    | ×    | ×   | ×        | ×                        | ×  | ×       | ×          | ×           | ×  | ×  |
| integer              | ×  | ×  | ×    | ×        | ×                         | ×   | ×       | ×      | ×          | ×    | ×    |
| integer unsigned  | ×   | × | ×   | ×       | ×                         | ×  | ×     | ×       | ×         | ×    | ×   |
| bigint             | ×  | ×   | ×   | ×       | ×                        | ×   | ×    | ×        | ×          | ×   | ×  |
| bigint unsigned     | ×  | ×    | ×    | ×      | ×                          | ×    | ×     | ×        | ×        | ×   | ×   |
| smallint            | ×  | ×   | ×  | ×       | ×                          | ×   | ×      | ×      | ×          | ×     | ×    |
| smallint unsigned | ×     | × | ×   | ×        | ×                         | ×    | ×      | ×         | ×          | ×    | ×    |
| bit                | ×  | ×   | ×   | ×       | ×                         | ×   | ×       | ×        | ×         | ×    | ×    |
| binary             | ×   | ×   | ×   | ×         | ×                          | ×   | ×       | ×          | ×          | ×  | ×   |
| varbinary          | ×   | ×   | × | ×        | ×                         | ×    | ×     | ×         | ×          | ×    | ×    |
| tinyblob           | ×   | ×   | ×  | ×         | ×                         | ×   | ×     | ×        | ×          | ×   | ×    |
| blob                | ×  | ×   | ×   | ×       | ×                         | ×    | ×      | ×        | ×          | ×    | ×  |
| mediumblob         | ×    | ×    | ×  | ×        | ×                         | × | ×      | ×        | ×          | ×  | ×    |
| longblob          | ×    | ×  | ×   | ×        | ×                         | ×   | ×       | ×        | ×           | ×   | ×   |
   
![](https://support.huaweicloud.com/usermanual-dbss/public_sys-resources/note_3.0-zh-cn.png)
- 主键不支持配置密钥，也不支持加密。
- DB2没有text类型，char类型在DB2中是定长的，会自动补充空格，所以不支持模糊匹配。
 
#### GaussDB
| 字段类型              | 加密 | 解密    | 完整性   | sdk新增入库密文 | sdk查询展示明文+脱敏 | sdk编辑 | sdk模糊查询 | 代理新增入库密文 | 代理查询展示明文+脱敏 | 代理编辑 | 代理模糊查询 |
|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|
| smallint          | ×   | ×   | ×    | ×         | ×          | ×    | ×      | ×       | ×         | ×  | ×     |
| integer          | ×    | ×    | ×  | ×        | ×          | ×    | ×     | ×     | ×           | ×  | ×       |
| int2              | ×  | ×  | ×    | ×         | ×        | ×       | ×    | ×    | ×          | ×  | ×      |
| int4             | ×   | ×    | ×   | ×         | ×          | ×     | ×     | ×    | ×          | ×    | ×     |
| int8            | × | ×   | ×     | ×         | ×         | ×     | ×      | ×        | ×        | ×    | ×    |
| bigint           | ×  | ×   | ×   | ×           | ×           | ×     | ×     | ×     | ×          | ×   | ×      |
| decimal         | ×   | ×   | ×   | ×          | ×           | ×      | ×    | ×        | ×           | ×   | ×     |
| numeric           | ×  | ×   | ×   | ×         | ×          | ×     | ×    | ×     | ×         | ×   | ×      |
| real               | ×    | ×  | ×   | ×         | ×          | ×     | ×      | ×      | ×         | ×    | ×      |
| float4            | ×   | ×  | ×  | ×          | ×         | ×        | ×     | ×      | ×           | ×   | ×       |
| double precision | ×    | ×   | ×   | ×          | ×            | ×          | ×    | ×      | ×          | ×   | ×        |
| float8             | ×    | ×    | ×   | ×         | ×             | ×    | ×    | ×      | ×          | ×      | ×      |
| varchar           | √  | √   | √  | √         | √         | √     | √     | √       | √          | √ | √      |
| char                | √     | √  | √  | √          | √           | √       | √       | √       | √         | √  | √     |
| bpchar            | √   | √ | √    | √        | √           | √      | √      | √       | √        | √    | √     |
| character          | √   | √   | √   | √         | √         | √     | √     | √      | √         | √   | √        |
| character varying  | √    | √  | √ | √         | √         | √      | √    | √       | √           | √   | √     |
| text               | √  | √  | √    | √          | √         | √      | √      | √    | √         | √    | √      |
| bytea             | ×    | ×  | ×  | ×         | ×          | ×      | ×    | ×     | ×          | ×    | ×      |
   
#### openGauss
| 字段类型             | 加密 | 解密  | 完整性 | sdk新增入库密文 | sdk查询展示明文+脱敏           | sdk编辑 | sdk模糊查询 | 代理新增入库密文 | 代理查询展示明文+脱敏 | 代理编辑 | 代理模糊查询 |
|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|
| varchar          | √  | √  | √  | √         | select\*不支持，select具体字段支持  | √      | √         | √        | √           | √   | √       |
| char             | √    | √     | √     | √         | select\*不支持，select具体字段支持 | √      | √       | √          | √          | √    | 左匹配×     |
| tinytext         | ×   | ×  | ×    | ×         | ×                       | ×     | ×       | ×          | ×          | ×     | ×      |
| text             | √ | √     | √     | √       | select\*不支持，select具体字段支持  | √     | √       | √         | √            | √    | √     |
| mediumtext         | ×   | ×   | ×    | ×        | ×                       | ×      | ×        | ×          | ×          | ×    | ×        |
| longtext         | ×  | ×  | ×  | ×         | ×                        | ×   | ×       | ×         | ×          | ×     | ×       |
| json             | ×  | ×  | ×  | ×         | ×                        | ×   | ×       | ×          | ×            | ×   | ×       |
| decimal           | ×   | ×    | ×     | ×        | ×                        | ×    | ×      | ×          | ×          | ×    | ×      |
| double           | ×    | × | ×    | ×      | ×                       | ×    | ×       | ×         | ×            | ×      | ×      |
| float             | ×  | ×  | ×    | ×        | ×                        | ×    | ×        | ×         | ×            | ×   | ×       |
| int              | ×   | × | ×    | ×         | ×                       | ×      | ×         | ×         | ×           | ×  | ×       |
| int unsigned      | ×   | ×   | ×    | ×       | ×                       | ×     | ×       | ×          | ×            | ×   | ×        |
| integer            | ×  | ×   | ×    | ×         | ×                        | ×    | ×       | ×           | ×            | ×   | ×       |
| integer unsigned   | ×   | ×    | ×   | ×         | ×                         | ×   | ×         | ×          | ×            | ×    | ×      |
| bigint           | ×   | × | ×    | ×         | ×                       | ×       | ×        | ×           | ×            | ×     | ×     |
| bigint unsigned  | ×    | ×    | ×   | ×       | ×                      | ×    | ×         | ×           | ×           | ×      | ×      |
| smallint           | ×    | ×   | ×     | ×        | ×                          | ×       | ×       | ×        | ×           | ×     | ×       |
| smallint unsigned | ×  | ×   | ×    | ×       | ×                          | ×   | ×      | ×          | ×           | ×      | ×       |
| bit               | ×    | ×    | ×     | ×        | ×                      | ×    | ×      | ×         | ×         | ×     | ×       |
| binary           | ×     | ×     | ×     | ×      | ×                      | ×    | ×       | ×           | ×            | ×    | ×       |
| varbinary          | ×   | ×    | ×    | ×        | ×                        | ×    | ×       | ×         | ×           | ×     | ×       |
| tinyblob           | ×   | × | ×  | ×        | ×                       | ×    | ×        | ×            | ×           | ×     | ×      |
| blob             | ×   | ×   | ×   | ×         | ×                      | ×       | ×        | ×          | ×          | ×   | ×      |
| mediumblob      | ×    | ×  | ×    | ×          | ×                         | ×     | ×       | ×        | ×             | ×    | ×      |
| longblob           | ×    | ×    | ×   | ×        | ×                      | ×   | ×      | ×          | ×            | ×    | ×       |
   
![](https://support.huaweicloud.com/usermanual-dbss/public_sys-resources/note_3.0-zh-cn.png)
主键不支持配置密钥，也不支持加密。
#### RDS for MySQL
| 字段类型               | 加密 | 解密 | 完整性 | sdk新增入库密文 | sdk查询展示明文+脱敏 | sdk编辑 | sdk模糊查询 | 代理新增入库密文 | 代理查询展示明文+脱敏 | 代理编辑 | 代理模糊查询 |
|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|
| varchar            | ×  | ×  | ×   | √      | √            | √     | √       | √    | √          | √   | √    |
| char              | × | × | ×   | √     | √           | √      | √       | √      | √         | √    | √   |
| tinytext         | × | ×   | ×   | ×     | ×           | ×      | ×        | ×    | ×           | ×    | ×     |
| text               | × | × | × | √       | √           | √      | √      | √    | √         | √  | √     |
| mediumtext        | ×   | ×    | ×   | ×        | ×              | ×     | ×        | ×       | ×            | ×   | ×      |
| longtext          | ×  | × | ×    | ×         | ×             | ×       | ×        | ×     | ×           | ×     | ×     |
| json               | × | ×  | ×   | ×         | ×           | ×      | ×       | ×     | ×           | ×   | ×      |
| decimal              | × | ×   | ×   | ×         | ×            | ×       | ×         | ×      | ×            | ×   | ×     |
| double              | ×   | ×  | ×   | ×       | ×              | ×     | ×         | ×      | ×             | ×    | ×      |
| float             | ×   | ×     | ×    | ×        | ×               | ×        | ×      | ×       | ×           | ×     | ×     |
| int                 | × | ×  | ×    | ×        | ×             | ×     | ×        | ×     | ×           | ×    | ×     |
| int unsigned      | ×   | ×  | ×    | ×         | ×              | ×        | ×         | ×        | ×           | ×  | ×     |
| integer             | ×  | × | ×    | ×       | ×             | ×      | ×        | ×       | ×          | ×     | ×     |
| integer unsigned    | ×  | ×    | ×     | ×       | ×             | ×     | ×         | ×     | ×         | ×    | ×   |
| bigint            | ×    | ×   | ×    | ×       | ×              | ×       | ×       | ×        | ×            | ×     | ×      |
| bigint unsigned     | ×  | ×   | ×  | ×         | ×             | ×       | ×       | ×     | ×           | ×    | ×   |
| smallint         | ×    | ×  | ×     | ×          | ×              | ×       | ×       | ×      | ×          | ×   | ×     |
| smallint unsigned | × | ×   | ×    | ×        | ×              | ×       | ×        | ×       | ×          | ×  | ×     |
| bit                  | ×  | ×    | ×     | ×         | ×              | ×        | ×        | ×     | ×           | ×     | ×      |
| binary             | × | ×    | ×   | ×         | ×           | ×      | ×       | ×      | ×            | ×     | ×      |
| varbinary         | ×  | ×  | ×     | ×       | ×            | ×         | ×        | ×      | ×            | ×   | ×     |
| tinyblob           | × | ×    | ×     | ×        | ×             | ×         | ×        | ×        | ×          | ×    | ×   |
| blob               | × | ×  | ×   | ×         | ×             | ×      | ×        | ×      | ×           | ×   | ×     |
| mediumblob           | ×   | ×  | ×    | ×       | ×           | ×        | ×        | ×    | ×           | ×   | ×    |
| longblob          | ×    | ×   | ×   | ×        | ×            | ×        | ×         | ×      | ×           | ×    | ×       |
   
![](https://support.huaweicloud.com/usermanual-dbss/public_sys-resources/note_3.0-zh-cn.png)
主键不支持配置密钥，也不支持加密。
#### RDS for PostgreSQL
| 字段类型               | 加密   | 解密   | 完整性  | sdk新增入库密文 | sdk查询展示明文+脱敏 | sdk编辑 | sdk模糊查询 | 代理新增入库密文 | 代理查询展示明文+脱敏 | 代理编辑  | 代理模糊查询 |
|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|
| smallint          | ×    | ×   | ×   | ×       | ×            | ×    | ×     | ×      | ×          | × | ×       |
| integer             | ×   | ×  | ×   | ×         | ×            | ×   | ×      | ×      | ×          | ×  | ×     |
| int2                 | ×   | ×    | ×   | ×         | ×            | ×    | ×      | ×        | ×          | ×  | ×     |
| int4                | ×    | × | ×  | ×        | ×           | ×     | ×      | ×       | ×          | ×   | ×     |
| int8               | ×  | ×   | ×  | ×        | ×              | ×   | ×      | ×      | ×           | ×   | ×       |
| bigint              | ×    | ×   | ×    | ×        | ×            | ×    | ×       | ×        | ×          | ×  | ×       |
| decimal             | ×   | ×    | × | ×        | ×            | ×     | ×      | ×        | ×         | ×   | ×     |
| numeric           | ×   | ×    | ×    | ×        | ×            | ×    | ×        | ×      | ×          | ×   | ×     |
| real              | ×   | ×    | ×   | ×          | ×             | ×    | ×      | ×        | ×          | ×  | ×       |
| float4           | ×   | ×  | ×    | ×      | ×          | ×    | ×        | ×      | ×          | ×     | ×      |
| double precision    | × | ×   | ×   | ×        | ×            | ×   | ×     | ×         | ×          | ×  | ×      |
| float8              | ×   | ×  | × | ×         | ×             | ×     | ×        | ×      | ×          | × | ×      |
| varchar            | √  | √   | √   | √        | √            | √   | √      | √       | √           | √  | √     |
| char             | √  | √  | √   | √         | √             | √     | √      | √       | √          | √    | √      |
| bpchar             | ×   | ×   | ×   | ×        | ×             | ×      | ×       | ×       | ×           | ×   | ×       |
| character          | ×     | ×    | ×     | ×        | ×             | ×    | ×          | ×       | ×         | ×  | ×          |
| character varying | ×    | ×   | ×  | ×         | ×             | ×      | ×      | ×      | ×         | ×  | ×     |
| text               | √  | √ | √     | √       | √           | √    | √        | √       | √          | √   | √      |
| bytea               | ×     | ×   | ×   | ×       | ×               | ×   | ×      | ×      | ×           | ×   | ×        |
   
#### RDS for MariaDB
| 字段类型                | 加密   | 解密   | 完整性 | sdk新增入库密文 | sdk查询展示明文+脱敏 | sdk编辑 | sdk模糊查询 | 代理新增入库密文 | 代理查询展示明文+脱敏 | 代理编辑 | 代理模糊查询 |
|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|
| varchar            | √     | √   | √   | √          | √             | √       | √        | √         | √            | √    | √         |
| char               | √     | √    | √    | √           | √            | √       | √        | √      | √             | √     | √        |
| tinytext           | ×  | ×    | × | ×          | ×            | ×     | ×      | ×      | ×          | ×      | ×          |
| text               | √     | √      | √ | √           | √               | √      | √      | √          | √            | √     | √         |
| mediumtext         | ×  | ×  | ×  | ×          | ×           | ×     | ×      | ×       | ×          | ×     | ×       |
| longtext          | ×  | ×    | ×  | ×          | ×           | ×      | ×      | ×        | ×          | ×   | ×        |
| json              | ×  | ×  | × | ×         | ×            | ×    | ×      | ×      | ×          | ×     | ×        |
| decimal         | ×     | ×  | ×   | ×           | ×             | ×    | ×        | ×       | ×           | ×    | ×        |
| double             | ×   | ×    | × | ×         | ×           | ×       | ×      | ×       | ×           | ×    | ×       |
| float            | ×  | ×   | × | ×           | ×            | ×     | ×     | ×       | ×            | ×   | ×          |
| int              | ×   | ×   | × | ×          | ×             | ×      | ×      | ×      | ×         | ×    | ×       |
| int unsigned      | ×     | ×    | ×   | ×          | ×           | ×      | ×      | ×        | ×          | ×    | ×       |
| integer            | ×   | ×    | ×  | ×          | ×            | ×      | ×        | ×        | ×         | ×     | ×        |
| integer unsigned | ×  | × | × | ×          | ×             | ×     | ×       | ×      | ×            | ×    | ×      |
| bigint             | ×   | ×  | ×  | ×           | ×             | ×    | ×       | ×       | ×           | ×     | ×         |
| bigint unsigned     | ×  | ×    | ×  | ×         | ×             | ×   | ×       | ×      | ×             | ×      | ×        |
| smallint          | ×   | ×   | ×    | ×           | ×           | ×     | ×         | ×        | ×           | ×  | ×      |
| smallint unsigned | ×  | ×    | × | ×          | ×             | ×    | ×        | ×      | ×           | ×    | ×       |
| bit               | ×    | ×   | × | ×         | ×           | ×      | ×       | ×        | ×            | ×    | ×         |
| binary             | ×  | ×    | ×  | ×         | ×           | ×      | ×       | ×      | ×           | ×     | ×        |
| varbinary         | ×   | ×    | ×  | ×         | ×           | ×    | ×       | ×        | ×           | ×    | ×       |
| tinyblob        | ×  | ×  | ×   | ×           | ×              | ×     | ×        | ×      | ×            | ×   | ×         |
| blob              | × | ×    | ×   | ×           | ×          | ×   | ×        | ×      | ×           | ×   | ×         |
| mediumblob        | ×   | ×    | ×   | ×           | ×            | ×       | ×        | ×         | ×           | ×     | ×         |
| longblob          | ×   | ×    | ×   | ×         | ×             | ×     | ×       | ×        | ×          | ×    | ×       |
   
![](https://support.huaweicloud.com/usermanual-dbss/public_sys-resources/note_3.0-zh-cn.png)
主键不支持配置密钥，也不支持加密。
#### RDS for SQL Sever
| 字段类型             | 加密 | 解密   | 完整性 | sdk新增入库密文 | sdk查询展示明文+脱敏 | sdk编辑 | sdk模糊查询 | 代理新增入库密文 | 代理查询展示明文+脱敏 | 代理编辑 | 代理模糊查询 |
|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|
| bigint         | ×  | ×    | ×    | ×        | ×            | ×    | ×     | ×          | ×            | ×     | ×     |
| binary          | × | ×   | ×    | ×       | ×            | ×   | ×       | ×         | ×           | ×      | ×     |
| char              | √ | √   | √   | √        | √             | √     | √     | ×       | ×           | ×     | ×     |
| int              | × | ×   | ×  | ×         | ×            | ×     | ×     | ×         | ×            | ×       | ×      |
| varchar         | √  | √   | √  | √         | √           | √    | √      | ×         | ×              | ×     | ×      |
| text             | √   | √   | √ | √        | √            | √   | √        | ×        | ×            | ×    | ×    |
| decimal       | ×   | ×  | ×    | ×       | ×              | ×     | ×      | ×      | ×             | ×    | ×     |
| float         | ×  | ×   | ×    | ×      | ×             | ×    | ×      | ×         | ×           | ×    | ×    |
| image            | ×   | ×  | ×  | ×       | ×               | ×    | ×       | ×        | ×          | ×     | ×     |
| money           | × | ×  | ×  | ×       | ×             | ×    | ×       | ×        | ×          | ×    | ×      |
| nchar          | ×  | ×   | ×   | ×       | ×            | ×     | ×      | ×       | ×           | ×   | ×    |
| ntext           | ×   | ×    | × | ×       | ×            | ×     | ×       | ×        | ×          | ×     | ×    |
| numeric         | × | ×    | ×   | ×        | ×             | ×    | ×      | ×       | ×         | ×     | ×       |
| nvarchar       | ×   | ×     | × | ×       | ×             | ×   | ×     | ×      | ×           | ×  | ×      |
| nvarchar（max）   | ×   | ×     | ×   | ×          | ×           | ×    | ×        | ×      | ×          | ×     | ×      |
| varbinary        | ×  | ×   | ×    | ×        | ×             | ×  | ×       | ×        | ×          | ×      | ×      |
| varbinary（max） | ×  | ×  | ×   | ×        | ×            | ×   | ×         | ×       | ×           | ×     | ×      |
| varchar（max）    | × | × | ×    | ×         | ×           | ×    | ×      | ×      | ×          | ×    | ×       |
| real            | × | ×    | ×   | ×        | ×           | ×     | ×       | ×         | ×            | ×     | ×    |
| smallint        | × | ×    | ×   | ×         | ×            | ×     | ×         | ×       | ×            | ×     | ×     |
| smallmoney        | ×  | × | ×   | ×        | ×             | ×  | ×        | ×        | ×            | ×     | ×    |
| tinyint         | ×    | ×   | ×  | ×        | ×            | ×    | ×        | ×       | ×         | ×    | ×    |
| datetime         | ×    | ×   | ×   | ×        | ×            | ×    | ×        | ×      | ×           | ×     | ×     |
| int identity    | ×  | ×   | ×   | ×         | ×            | ×    | ×      | ×        | ×         | ×   | ×    |
| xml             | ×    | ×    | ×  | ×       | ×              | ×      | ×      | ×     | ×          | ×    | ×      |
   
![](https://support.huaweicloud.com/usermanual-dbss/public_sys-resources/note_3.0-zh-cn.png)
- 勾选字段保存成逻辑主键后可支持加密和解密。
- SQL Server主键、索引不支持加密，不支持设置密钥。
 
#### RDS for TaurusDB
| 字段类型              | 加密  | 解密 | 完整性 | sdk新增入库密文 | sdk查询展示明文+脱敏 | sdk编辑 | sdk模糊查询 | 代理新增入库密文 | 代理查询展示明文+脱敏 | 代理编辑  | 代理模糊查询 |
|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|:---|
| varchar            | √     | √  | √    | √           | √             | √       | √       | ×           | ×             | ×    | ×        |
| char             | √   | √   | √    | √           | √            | √      | √      | ×         | ×           | ×    | ×      |
| tinytext          | ×   | ×  | ×  | ×          | ×            | ×      | ×       | ×         | ×            | ×     | ×     |
| text              | √     | √ | √   | √          | √             | √       | √      | ×         | ×            | ×     | ×      |
| mediumtext        | ×    | ×   | ×   | ×          | ×            | ×       | ×      | ×         | ×            | ×    | ×      |
| longtext          | ×  | ×  | ×  | ×        | ×             | ×    | ×      | ×        | ×             | ×    | ×      |
| json              | ×  | ×  | ×  | ×        | ×            | ×     | ×     | ×           | ×            | ×    | ×      |
| decimal           | ×   | ×   | ×   | ×         | ×           | ×     | ×    | ×        | ×            | ×   | ×      |
| double            | ×   | × | ×   | ×         | ×            | ×     | ×      | ×        | ×            | ×  | ×    |
| float              | × | ×  | ×    | ×       | ×            | ×     | ×     | ×         | ×            | × | ×      |
| int              | ×   | × | ×  | ×          | ×             | ×     | ×      | ×         | ×              | ×  | ×     |
| int unsigned       | ×  | ×  | ×   | ×       | ×            | ×      | ×        | ×       | ×            | ×  | ×      |
| integer          | ×  | ×  | ×   | ×           | ×            | ×    | ×       | ×        | ×            | ×   | ×       |
| integer unsigned   | ×   | ×  | ×   | ×        | ×           | ×       | ×      | ×        | ×            | ×  | ×       |
| bigint            | ×   | ×   | ×   | ×          | ×             | ×      | ×        | ×         | ×            | ×  | ×       |
| bigint unsigned    | ×   | ×  | ×   | ×           | ×           | ×     | ×      | ×         | ×            | ×    | ×      |
| smallint         | ×   | ×   | ×  | ×         | ×           | ×    | ×     | ×         | ×             | ×    | ×      |
| smallint unsigned | × | ×   | ×  | ×        | ×             | ×    | ×    | ×           | ×             | ×   | ×      |
| bit               | × | ×  | ×    | ×         | ×           | ×     | ×       | ×         | ×             | ×   | ×       |
| binary            | ×    | ×   | ×   | ×        | ×           | ×      | ×       | ×         | ×            | ×   | ×       |
| varbinary          | ×   | ×  | ×   | ×        | ×            | ×    | ×     | ×        | ×            | ×    | ×    |
| tinyblob         | ×   | ×  | ×   | ×          | ×            | ×    | ×    | ×         | ×          | ×    | ×       |
| blob                | ×   | × | ×    | ×        | ×            | ×     | ×     | ×         | ×           | ×   | ×      |
| mediumblob       | ×   | × | × | ×         | ×             | ×      | ×       | ×          | ×           | ×  | ×    |
| longblob         | ×  | ×  | ×   | ×          | ×            | ×    | ×       | ×         | ×           | ×     | ×       |
   
![](https://support.huaweicloud.com/usermanual-dbss/public_sys-resources/note_3.0-zh-cn.png)
主键不支持配置密钥，也不支持加密。