How can I decode base32 to string in mysql

Question

Im looking for a way to decode a string encrypted in base32 back to original string in mysql. I know there is a SP to do this with base64 but cannot find anything for base32.

Is it possible? is there a stored procedure I can use somewhere?

What are ways to implement this?

Thanks!

It is certainly possible. You could write your own SP, if you really have to do it on the DB side. Otherwise, see if you can find a solution in a language more appropriate for the task. — JimmyB
– JimmyB, Commented Feb 23, 2015 at 17:04

lnrdo · Accepted Answer · 2015-03-23 16:23:46Z

4

BASE 64 or BASE 32 are not encrypted, they are just encoded. MySQL does not have a native function to perform encoding/decoding of Base 32 strings as it has for Base 64, FROM_BASE_64 e TO_BASE_64.

As an alternative you can try the CONV mathematical function (depending on the content stored as BASE32). Lets say you have UUID numbers stored as DECIMAL and need to show them as BASE32 or vice versa:

SELECT uuid, conv(uuid, 10, 32) uuid_b32, conv(conv(uuid, 10, 32), 32, 10) 
FROM database.table;

The answer above is for number conversions between distinct base. If that is not the case, as when you have a binary file stored on a blob column, them you'll probably need to do the encoding/decoding outside MySQL. You may use MIME::Base32 or the proper module on your preferred language. Anyway, you'll need to know if the field has text or binary encoded in Base32.

edited Mar 23, 2015 at 16:23

answered Feb 23, 2015 at 17:01

lnrdo

4062 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I decode base32 to string in mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related