Help Center> GaussDB> Service Overview> Compatibility with MySQL Databases> Primary/Standby Instances> MySQL Compatibility in M-Compatible Mode> System Functions> Encryption Functions
Updated on 2024-05-14 GMT+08:00
View PDF

Encryption Functions

Table 1 Encryption functions

No.

MySQL

GaussDB

Difference

1

AES_DECRYPT()

Supported
  1. GaussDB does not support ECB mode, which is an insecure encryption mode, but uses CBC mode by default.
  2. When characters are specified to be encoded in SQL_ASCII for GaussDB, the server parses byte values 0 to 127 according to the ASCII standard, and byte values 128 to 255 cannot be parsed. If the input and output of the function contain any non-ASCII characters, the database cannot help you convert or verify them.
  3. The return value type in MySQL is BINARY, VARBINARY, BLOB, MEDIUMBLOB, or LONGBLOB, while the return value type in GaussDB is fixed to LONGBLOB.

2

AES_ENCRYPT()

Supported

3

SHA()/SHA1()

Supported

-

4

SHA2()

Supported

-
Parent topic: System Functions