I need to encrypt some data, store it in the database, and decrypt it in a client application. I see that SQLA11 has an ENCRYPT() method, which is great, but it only supports AES128 and AES256 encryption. Unfortunately, I can't decrypt using those methods. Is there any other means of encrypting data in SQLA? Perhaps RSA RC4?
asked 04 May '10, 17:12
Jason 'Bug' ...
SQL Anywhere offers AES and FIPS-approved AES encryption for the database file. For Transport Layer Security we offer RSA, FIPS-approved RSA and ECC encryption for the communication stream between the client application and the database. Is there a specific reason AES encryption for the database and RSA/ECC TLS is not sufficient?
answered 04 May '10, 20:28