Alternate Encryption Methods?

[Former Member]

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?

[Former Member]

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?

[Former Member]

As a comment, I do not see why calling an encryption method in the application, then inserting encrypted data into the database wouldn't work. Just make sure you using the same method for encrypting/decrypting the data.

[Former Member]

I have one system encrypting the data and a second system decrypting the data. This explanation may require more than one comment so...

The database has an exposed web service for registering customers. The client provides a couple of identifiers. The database validates them and generates a "key". This "key" is passed back to the client through said web service.

The client stores this key locally. The client must be able to decrypt this key and validate the contents. This is to keep someone from simply adding dummy keys to the local data store. That local data store may not be SQLA. (end)

[VolkerBarth]

@Jason: Then I think you should use an encryption method that is available outside the database (and wich might be used inside SA by means of an external procedure call). So maybe a classic C-style library might be useful.