-
Sarath Pappireddy
- PowerBuilder
- Monday, 13 January 2020 07:38 PM UTC
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?
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.