wrong insertion of Base 64 data insertion into sql nvarchar field

(0) Share

Report

Posted on by CU27040859-12

I have a field to encrypt in FO, I have encrypted the value and tried to insert it into SQL, but the actual value inserted is different from the actual encrypted value.
is there some specific method to insert the base 64 string?

For example a particular string I got the encrypted value as /xTIEbaHkxRnZVfg6U02vYg==/ but /w1vy4s5am604pog6e+n2vqg2fyo=/ is what I can find in the backend SQL.

All responses (5)

Answers (1)

Sort by

Martin Dráb 241,515 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You must have something wrong in your code, because the database wouldn't change the string to another one (unless there was a trigger, but in the case of F&O, almost all logic is in the application layer).

By the way, why do you use base64 at all? It consumes more disk space and processing power than storing binary data directly.
André Arnaud de Cal... 307,893 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Can you share the coding you wrote, so we can verify what might be wrong here?
CU27040859-12 6 on at

Like (0)

Report
Copy link

Link copied!

I have used the runnable class for the testing purpose of this task, I tried to print the value on screen using info fn. and then updated the existing value in the table.
in this scenario I am getting different values on my info statement and SQL

my code like like this in a runnable class

select forupdate vendtable where vendtable.AccountNum = '001'
{
str encStr;
encStr = EncryptDecrypt::encrypt(vendtable.Tax1099RegNum,int2Str(tableNum(VendTable)));
Info(encStr);

ttsbegin
vendtable.Tax1099RegNum = encryptDecrypt::encrypt(vendtable.Tax1099RegNum,int2Str(tableNum(VendTable)));
vendtable.update();
ttscommit;

}
Martin Dráb 241,515 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Let's change your test case a little bit:
ttsbegin; select firstOnly forUpdate vendTable where vendTable.AccountNum = '001'; vendTable.Tax1099RegNum = EncryptDecrypt::encrypt(vendtable.Tax1099RegNum, int2Str(tableNum(VendTable))); vendTable.doUpdate(); info(strFmt("RecId: %1, value %2", vendTable.RecId, vendTable.Tax1099RegNum)); ttscommit;

Then find the record in DB by RecId and compare the value of Tax1099RgNum field. What is the result?

I'll be easier than dealing with several records at once, we check actual the value of the field.
Verified answer

Martin Dráb 241,515 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Maybe I see the problem. If it's a US company, the value returned by encrypt() isn't what is sent to database, because update() method changes the value (this.Tax1099RegNum = Tax1099ElectronicCheck::formatTIN(this.Tax1099RegNum, this.TaxIDType)).