Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.


Encrypts the given ciphertext using the AES (Advanced Encryption Standard) algorithm, with a 128-bit key.


AES_ENCRYPT(ciphertext, key)


  • ciphertext: the binary data to encrypt
  • key: the text or binary key to use for encryption

Return Type

The “ciphertext” of encrypted data, in binary.


Note: the HEX function is used in this example to make it easier to handle binary data.

select hex(AES_ENCRYPT('secret message', 'ohai'));
| hex(AES_ENCRYPT('secret message', 'ohai')) |
| C958FF3BC0134ADE4A8F952338C1FAEC           |

Related Topics