Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Determines if a string is encrypted using the ENCRYPT function and the specified key.
ISENCRYPTED( string, key[, algorithm ] )
The string to be analyzed to determine if it is encrypted. This parameter is case sensitive, even in case-insensitive
The encryption key used to encrypt the string. This parameter is case sensitive, even in case-insensitive databases.
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.
RSA 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
ISENCRYPTED returns 1 when the input string is encrypted with the specified key; otherwise it returns 0.
The following statement returns the value 1 because the input string is encrypted:
SELECT ISENCRYPTED( ENCRYPT ('test_string', 'key' ), 'key');