DECRYPT (algorithmString , keyBytes , dataBytes)

Parameters

• algorithmString - sets a supported AES algorithm.
• keyBytes - sets a key.
• dataBytes - sets data.

Description

Decrypts data using a key. The supported algorithm is AES. The block size is 16 bytes. This method returns bytes.

Example

Decrypt Players' names:

SELECT DECRYPT('AES', '00', '3fabb4de8f1ee2e97d7793bab2db1116'))) FROM Player;