ISENCRYPTED function [System]

ISENCRYPTED( string, key[, algorithm ] )

INT

string The string to be analyzed to determine if it is encrypted. This parameter is case sensitive, even in case-insensitive databases.
key The encryption key used to encrypt the string. This parameter is case sensitive, even in case-insensitive databases.
algorithm This optional parameter specifies the algorithm used when the string was encrypted. Supported algorithms include: AES, AES256, AES_FIPS, and AES256_FIPS.
You can specify one of the FIPS-certified algorithms for algorithm on any platform that supports FIPS-certified encryption.

Note

RSA, ECC, and FIPS-certified encryption are not available on all platforms. For information about which platforms support which encryption method, see http://www.sybase.com/detail?id=1061806.

If algorithm is not specified, AES is used by default. If the database server was started using the -fips server option, the default is AES_FIPS.

ISENCRYPTED returns 1 when the input string is encrypted with the specified key; otherwise it returns 0.

The following fragment illustrates the use of the ISENCRYPTED function:

SELECT ISENCRYPTED( ENCRYPT ('test_string', 'key' ), 'key');