You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

Encryption Functions

MD5(String)

Calculates an MD5 checksum for the string.

SHA1(String)

Calculates an SHA-1 checksum for the string.

SHA256(String)

Calculates an SHA-265 checksum for the string.

SHA384(String)

Calculates an SHA-384 checksum for the string.

SHA512(String)

Calculates an SHA-512 checksum for the string.

DSA(Number)

Generates a DSA key pair of the given size.

RSA(Number)

Generates a RSA key pair of the given size.

RSASign(Object,String : Private Key)

Computes a signature for the given object with the given private key.

Example
SELECT rsaSign("Hello World", "30820154020100300D...) FROM Stream
=> 51DC22BAFD51B112C72...

RSAVerify(Object, String : Signature, String : Public Key)

Verifies the signature for the given object with the given public key.

Example
SELECT rsaVerify("Hello World", "51DC22BAFD51B112C72...", "305C300D06092A8648...) FROM Stream
=> true

  • No labels