Hi. I found the answer in the code sample in the topic ' DECRYPT requiring UTF8TOSTRING and TRIM functions '. Sorry for posting.
On Jan 30, 10:52 pm, Thotheolh <[email protected]> wrote: > Hi. I used H2's encrypt and decrypt sql statements and below is the > result all are in hex codes: > > Plain text: 54657374696e672043727970746f2031323334 > Cipher text: > 5effffffc15fffffffc46b26ffffffcd56ffffffdfffffffd0113556ffffffcd2ffffff9bffffffd1ffffffa4670fffffff1fffffff640ffffffc7761ffffffb5ffffffb2ffffffb36ffffffcb > Plain text: 54657374696e672043727970746f20313233340000000000000 > > Why are there trailing zeroes after I decrypted the plain text ? > > If the hex are converted to ascii... the original plain text in ascii > is 'Testing Crypto 1234' and the decrypted text ascii is 'Testing > Crypto 1234???????'. It is a match except the trailing ??????. What > should i do to remove it ? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
