Hi Appeon Team,
We are trying to Implement the DB Encryption/Decryption in one of the our application using PB 2017 R3 and SQL ANYWHERE 17.
To Implement Encryption, we have initialized 3 Vector key values(CV_VCTR,CV_KEKY and CV_CEKY), which will be available for all DB users based on the logged in DB user.
Below is the logic we are using to encrypt the Column Values:
SELECT CAST(encrypt(:column_value,CV_CEKY,'AES256(format=raw;padding=zeroes)',CV_VCTR) AS Varchar(200)) FROM DUMMY;
The above statement is encrypting correctly for all values when we execute in DATABASE.
But when we try to execute same SQL statement from PB 2017 environment, its not returning proper encrypted values for few column values(its working Majority values but not for all ).
Can any one from Appeon Team confirm whether AES256 encryption is supported by PB 2017 or not?
select decrypt(:as_column_value,CV_CEKY,'AES256(format=raw;padding=zeroes)',CV_VCTR) FROM DUMMY;
For most of the scenarios its working but few scenarios this is not working either using blob or string conversion also.
I tried using the Code Object also, but its failing during decryption.
We have .NET and PowerBuilder applications, so we are trying to implement common encryption method using DB encryption which supports both platforms.
I think we have issue with PB IDE like way of interpreting the character set for few strings. because many strings this is working but few strings this is not working.
. conversion and if I start using Base64 encoding decoding approach itself is changing to different route