base64 encode is not matching with Oracle's base64 encode

Dinu2
New Contributor III

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
Databricks MVP

Oracle handles base64 encoding a little bit differently.

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

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