cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

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

2 REPLIES 2

daniel_sahal
Esteemed Contributor

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
Community Manager
Community Manager

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.

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!