HI all,
I was trying the systools function base64 encode and decode but I have a little problem with the decode...
here's a test case:
This is the result:
Checking the result with the site: https://www.base64encode.org/
it seems the same.
Now I want to decode it, it seems simple, but I can't return to 'Test base 64'.
What I'm doing wrong?
Many thanks
I was trying the systools function base64 encode and decode but I have a little problem with the decode...
here's a test case:
Code:
Create Table Testbase64(Rowid Int Not Null Generated Always As Identity (Start With 1, Increment By 1, No Cache), Fieldutf8 Varchar(4096) ccsid 1208 Not Null With Default, Fieldbase64 Varchar(4096) ccsid 1208 Not Null With Default); Insert Into Testbase64(Fieldutf8) Values ('Test base 64'); Update Testbase64 Set Fieldbase64 = Systools.Base64encode(Fieldutf8) Where Rowid = 1; Select *From testbase64;
1 | Test base 64 | VGVzdCBiYXNlIDY0 |
it seems the same.
Now I want to decode it, it seems simple, but I can't return to 'Test base 64'.
What I'm doing wrong?
Code:
Update Testbase64 Set Fieldutf8 = Systools.Base64decode(Fieldbase64) Where Rowid = 1;
Comment