0

My Table::

create table test_image (
  id int(10) not null AUTO_INCREMENT PRIMARY KEY,
  name varchar(25) not null default '',
  image blob not null
);

SELECT * from test_image;

How to apply Base 64 encoding in this table here

i want to convert binary image data to textual result

Any Ideas

Improve this question
5
  • In MySQL? You can not. Why not do that in application? Commented Sep 17, 2013 at 6:10
  • cough dev.mysql.com/doc/refman/5.6/en/… cough but that wont work very well with your blob, if I remember right text functions are limited to varchar4000 Commented Sep 17, 2013 at 6:10
  • What programming language are you using? Commented Sep 17, 2013 at 6:39
  • I am using expressJS ..... please Have a look at the detailed question i posted here stackoverflow.com/q/18842874/2609157 Commented Sep 17, 2013 at 6:42
  • Check this question. Googling your question before asking will save you a lot of time. Commented Sep 17, 2013 at 6:46
Related questions
58
base64 encode in MySQL
0
Storing strings in MySQL
1
Convert base64 encoded database
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.