Data Type Compatibility List_Support and Compatibility List_Series 2_Database Encryption_User Guide

MySQL

Field Type	Encryption	Decryption	Integrity	SDK: Encrypting New Records	SDK: Query Result as Plaintext + Masking	SDK: Editing	SDK: Fuzzy Query	Proxy: Encrypting New Records	Proxy: Query Result as Plaintext + Masking	Proxy: Editing	Proxy: Fuzzy Query
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	×	×	×	×	×	×	×	×	×	×	×

The primary key cannot be configured with a key or encrypted.

MariaDB

Field Type	Encryption	Decryption	Integrity	SDK: Encrypting New Records	SDK: Query Result as Plaintext + Masking	SDK: Editing	SDK: Fuzzy Query	Proxy: Encrypting New Records	Proxy: Query Result as Plaintext + Masking	Proxy: Editing	Proxy: Fuzzy Query
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	×	×	×	×	×	×	×	×	×	×	×

The primary key cannot be configured with a key or encrypted.

Oracle

Field Type	Encryption	Decryption	Integrity	SDK: Encrypting New Records	SDK: Query Result as Plaintext + Masking	SDK: Editing	SDK: Fuzzy Query
CHAR	√	√	×	√	√	√	√
VARCHAR	√	√	×	√	√	√	√
NCHAR	×	×	×	×	×	×	×
VARCHAR2	√	√	×	√	√	√	√
NVARCHAR2	×	×	×	×	×	×	×
CLOB	×	×	×	×	×	×	×
NCLOB	×	×	×	×	×	×	×
LONG	×	×	×	×	×	×	×
NUMBER	×	×	×	×	×	×	×
FLOAT	×	×	×	×	×	×	×

Encryption and decryption can be performed without setting the logical primary key.
For the CLOB and NCLOB types, data can be decrypted when it is queried in the plug-in. If the query condition contains the CLOB or NCLOB type, only the LIKE mode is supported. Other modes are not supported.

MS SQL Server

Field Type	Encryption	Decryption	Integrity	SDK: Encrypting New Records	SDK: Query Result as Plaintext + Masking	SDK: Editing	SDK: Fuzzy Query	Proxy: Encrypting New Records	Proxy: Query Result as Plaintext + Masking	Proxy: Editing	Proxy: Fuzzy Query
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	×	×	×	×	×	×	×	×	×	×	×

After the selected fields are saved as logical primary keys, they can be encrypted and decrypted.

The primary key and index of the SQL Server database cannot be encrypted, and the key cannot be set.

PostgresSQL

Field Type	Encryption	Decryption	Integrity	SDK: Encrypting New Records	SDK: Query Result as Plaintext + Masking	SDK: Editing	SDK: Fuzzy Query	Proxy: Encrypting New Records	Proxy: Query Result as Plaintext + Masking	Proxy: Editing	Proxy: Fuzzy Query
smallint	×	×	×	×	×	×	×	×	×	×	×
integer	×	×	×	×	×	×	×	×	×	×	×
int2	×	×	×	×	×	×	×	×	×	×	×
int4	×	×	×	×	×	×	×	×	×	×	×
int8	×	×	×	×	×	×	×	×	×	×	×
bigint	×	×	×	×	×	×	×	×	×	×	×
decimal	×	×	×	×	×	×	×	×	×	×	×
numeric	×	×	×	×	×	×	×	×	×	×	×
real	×	×	×	×	×	×	×	×	×	×	×
float4	×	×	×	×	×	×	×	×	×	×	×
double precision	×	×	×	×	×	×	×	×	×	×	×
float8	×	×	×	×	×	×	×	×	×	×	×
varchar	√	√	√	√	√	√	√	√	√	√	√
char	√	√	√	√	√	√	√	√	√	√	√
bpchar	×	×	×	×	×	×	×	×	×	×	×
character	×	×	×	×	×	×	×	×	×	×	×
character varying	×	×	×	×	×	×	×	×	×	×	×
text	√	√	√	√	√	√	√	√	√	√	√
bytea	×	×	×	×	×	×	×	×	×	×	×

Greemplum

Field Type	Encryption	Decryption	Integrity	SDK: Encrypting New Records	SDK: Query Result as Plaintext + Masking	SDK: Editing	SDK: Fuzzy Query	Proxy: Encrypting New Records	Proxy: Query Result as Plaintext + Masking	Proxy: Editing	Proxy: Fuzzy Query
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	×	×	×	×	×	×	×	×	×	×	×

The primary key cannot be configured with a key or encrypted.
The char and bpchar columns do not support fuzzy match.

Dameng

Field Type	Encryption	Decryption	Integrity	SDK: Encrypting New Records	SDK: Query Result as Plaintext + Masking	SDK: Editing	SDK: Fuzzy Query	Proxy: Encrypting New Records	Proxy: Query Result as Plaintext + Masking	Proxy: Editing	Proxy: Fuzzy Query
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	×	×	×	×	×	×	×	×	×	×	×

The primary key cannot be configured with a key or encrypted.

DB2

Field Type	Encryption	Decryption	Integrity	SDK: Encrypting New Records	SDK: Query Result as Plaintext + Masking	SDK: Editing	SDK: Fuzzy Query	Proxy: Encrypting New Records	Proxy: Query Result as Plaintext + Masking	Proxy: Editing	Proxy: Fuzzy Query
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	×	×	×	×	×	×	×	×	×	×	×

The primary key cannot be configured with a key or encrypted.
DB2 does not support the text type. The char type in DB2 is fixed-length and automatically adds spaces. Therefore, fuzzy match is not supported.

Kingbase (MySQL Mode)

Field Type	Encryption	Decryption	Integrity	SDK: Encrypting New Records	SDK: Query Result as Plaintext + Masking	SDK: Editing	SDK: Fuzzy Query	Proxy: Encrypting New Records	Proxy: Query Result as Plaintext + Masking	Proxy: Editing	Proxy: Fuzzy Query
int2	×	×	×	×	×	×	×	×	×	×	×
int4	×	×	×	×	×	×	×	×	×	×	×
int8	×	×	×	×	×	×	×	×	×	×	×
numeric	×	×	×	×	×	×	×	×	×	×	×
real	×	×	×	×	×	×	×	×	×	×	×
float4	×	×	×	×	×	×	×	×	×	×	×
float8	×	×	×	×	×	×	×	×	×	×	×
varchar	√	√	√	√	√	√	√	√	√	√	√
char	√	√	√	√	√	√	√	√	√	√	√
bpchar	×	×	×	×	×	×	×	×	×	×	×
text	√	×	√	√	√	√	√	√	√	√	√
jsonb	×	×	×	×	×	×	×	×	×	×	×
json	√	√	√	×	×	×	×	×	×	×	×
bytea	×	×	×	×	×	×	×	×	×	×	×
blob	×	×	×	×	×	×	×	×	×	×	×

DWS_GAUSSDB

Field Type	Encryption	Decryption	Integrity	SDK: Encrypting New Records	SDK: Query Result as Plaintext + Masking	SDK: Editing	SDK: Fuzzy Query	Proxy: Encrypting New Records	Proxy: Query Result as Plaintext + Masking	Proxy: Editing	Proxy: Fuzzy Query
varchar	√	√	√	√	SELECT * does not apply masking; masking works only when specific fields are selected.	√	√	√	√	√	√
char	√	√	√	√	SELECT * does not apply masking; masking works only when specific fields are selected.	√	√	√	√	√	×
tinytext	×	×	×	×	×	×	×	×	×	×	×
text	√	√	√	√	SELECT * does not apply masking; masking works only when specific fields are selected.	√	√	√	√	√	√
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	×	×	×	×	×	×	×	×	×	×	×

The primary key cannot be configured with a key or encrypted.
DB2 does not support the text type. The char type in DB2 is fixed-length and automatically adds spaces. Therefore, fuzzy match is not supported.

GaussDB

Field Type	Encryption	Decryption	Integrity	SDK: Encrypting New Records	SDK: Query Result as Plaintext + Masking	SDK: Editing	SDK: Fuzzy Query	Proxy: Encrypting New Records	Proxy: Query Result as Plaintext + Masking	Proxy: Editing	Proxy: Fuzzy Query
smallint	×	×	×	×	×	×	×	×	×	×	×
integer	×	×	×	×	×	×	×	×	×	×	×
int2	×	×	×	×	×	×	×	×	×	×	×
int4	×	×	×	×	×	×	×	×	×	×	×
int8	×	×	×	×	×	×	×	×	×	×	×
bigint	×	×	×	×	×	×	×	×	×	×	×
decimal	×	×	×	×	×	×	×	×	×	×	×
numeric	×	×	×	×	×	×	×	×	×	×	×
real	×	×	×	×	×	×	×	×	×	×	×
float4	×	×	×	×	×	×	×	×	×	×	×
double precision	×	×	×	×	×	×	×	×	×	×	×
float8	×	×	×	×	×	×	×	×	×	×	×
varchar	√	√	√	√	√	√	√	√	√	√	√
char	√	√	√	√	√	√	√	√	√	√	√
bpchar	√	√	√	√	√	√	√	√	√	√	√
character	√	√	√	√	√	√	√	√	√	√	√
character varying	√	√	√	√	√	√	√	√	√	√	√
text	√	√	√	√	√	√	√	√	√	√	√
bytea	×	×	×	×	×	×	×	×	×	×	×

openGauss

Field Type	Encryption	Decryption	Integrity	SDK: Encrypting New Records	SDK: Query Result as Plaintext + Masking	SDK: Editing	SDK: Fuzzy Query	Proxy: Encrypting New Records	Proxy: Query Result as Plaintext + Masking	Proxy: Editing	Proxy: Fuzzy Query
varchar	√	√	√	√	SELECT * does not apply masking; masking works only when specific fields are selected.	√	√	√	√	√	√
char	√	√	√	√	SELECT * does not apply masking; masking works only when specific fields are selected.	√	√	√	√	√	Left-anchored matching does not work.
tinytext	×	×	×	×	×	×	×	×	×	×	×
text	√	√	√	√	SELECT * does not apply masking; masking works only when specific fields are selected.	√	√	√	√	√	√
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	×	×	×	×	×	×	×	×	×	×	×

The primary key cannot be configured with a key or encrypted.

RDS for MySQL

Field Type	Encryption	Decryption	Integrity	SDK: Encrypting New Records	SDK: Query Result as Plaintext + Masking	SDK: Editing	SDK: Fuzzy Query	Proxy: Encrypting New Records	Proxy: Query Result as Plaintext + Masking	Proxy: Editing	Proxy: Fuzzy Query
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	×	×	×	×	×	×	×	×	×	×	×

The primary key cannot be configured with a key or encrypted.

RDS for PostgreSQL

Field Type	Encryption	Decryption	Integrity	SDK: Encrypting New Records	SDK: Query Result as Plaintext + Masking	SDK: Editing	SDK: Fuzzy Query	Proxy: Encrypting New Records	Proxy: Query Result as Plaintext + Masking	Proxy: Editing	Proxy: Fuzzy Query
smallint	×	×	×	×	×	×	×	×	×	×	×
integer	×	×	×	×	×	×	×	×	×	×	×
int2	×	×	×	×	×	×	×	×	×	×	×
int4	×	×	×	×	×	×	×	×	×	×	×
int8	×	×	×	×	×	×	×	×	×	×	×
bigint	×	×	×	×	×	×	×	×	×	×	×
decimal	×	×	×	×	×	×	×	×	×	×	×
numeric	×	×	×	×	×	×	×	×	×	×	×
real	×	×	×	×	×	×	×	×	×	×	×
float4	×	×	×	×	×	×	×	×	×	×	×
double precision	×	×	×	×	×	×	×	×	×	×	×
float8	×	×	×	×	×	×	×	×	×	×	×
varchar	√	√	√	√	√	√	√	√	√	√	√
char	√	√	√	√	√	√	√	√	√	√	√
bpchar	×	×	×	×	×	×	×	×	×	×	×
character	×	×	×	×	×	×	×	×	×	×	×
character varying	×	×	×	×	×	×	×	×	×	×	×
text	√	√	√	√	√	√	√	√	√	√	√
bytea	×	×	×	×	×	×	×	×	×	×	×

RDS for MariaDB

Field Type	Encryption	Decryption	Integrity	SDK: Encrypting New Records	SDK: Query Result as Plaintext + Masking	SDK: Editing	SDK: Fuzzy Query	Proxy: Encrypting New Records	Proxy: Query Result as Plaintext + Masking	Proxy: Editing	Proxy: Fuzzy Query
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	×	×	×	×	×	×	×	×	×	×	×

The primary key cannot be configured with a key or encrypted.

RDS for SQL Sever

Field Type	Encryption	Decryption	Integrity	SDK: Encrypting New Records	SDK: Query Result as Plaintext + Masking	SDK: Editing	SDK: Fuzzy Query	Proxy: Encrypting New Records	Proxy: Query Result as Plaintext + Masking	Proxy: Editing	Proxy: Fuzzy Query
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	×	×	×	×	×	×	×	×	×	×	×

After the selected fields are saved as logical primary keys, they can be encrypted and decrypted.
The primary key and index of the SQL Server database cannot be encrypted, and the key cannot be set.

RDS for TaurusDB

Field Type	Encryption	Decryption	Integrity	SDK: Encrypting New Records	SDK: Query Result as Plaintext + Masking	SDK: Editing	SDK: Fuzzy Query	Proxy: Encrypting New Records	Proxy: Query Result as Plaintext + Masking	Proxy: Editing	Proxy: Fuzzy Query
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	×	×	×	×	×	×	×	×	×	×	×

The primary key cannot be configured with a key or encrypted.

Data Type Compatibility List

MySQL

MariaDB

Oracle

MS SQL Server

PostgresSQL

Greemplum

Dameng

DB2

Kingbase (MySQL Mode)

DWS_GAUSSDB

GaussDB

openGauss

RDS for MySQL

RDS for PostgreSQL

RDS for MariaDB

RDS for SQL Sever

RDS for TaurusDB

What is your overall rating for this page?