base64 encode is not matching with Oracle's base64 encode

[Dinu2]

Hi , base64 encode is not matching with Oracle's base64 encode. please see below result. Could anyone help me on this?

In Azure Databricks: encoded= base64.b64encode(b'952B8D04E5CFB9BE')

output is - b'OTUyQjhEMDRFNUNGQjlCRQ=='

In Oracle: select utl_encode.base64_encode('952B8D04E5CFB9BE') from dual;

output is - 6C53754E424F58507562343D

[daniel_sahal]

Oracle handles base64 encoding a little bit differently.

Please check this link to understand what's the difference:

https://dba.stackexchange.com/a/129134

[Kaniz]

Hi @Dinu Sukumara​, We haven’t heard from you since the last response from @Daniel Sahal​, and I was checking back to see if his suggestions helped you.

Or else, If you have any solution, please do share that with the community as it can be helpful to others.

Also, Please don't forget to click on the "Select As Best" button whenever the information provided helps resolve your question.