base64 encode in MySQL

BCS_1343 0
Viewed 148449

I want to select a blob col from one table, base64 encode it and insert it into another tables. Is there any way to do this without round tripping the data out of the DB and through my app?

base64 mysql
8 Answers

Looks like no, though it was requested, and there’s a UDF for it.

Edit: Or there’s… this. Ugh.

ieure_452240

create table encrypt(username varchar(20),password varbinary(200))

insert into encrypt values('raju',aes_encrypt('kumar','key')) select *,cast(aes_decrypt(password,'key') as char(40)) from encrypt where username='raju';

user_98285120
Related