java string to varbinary

Question

background

I have an android client which sends image as string base64 to a jersey web service, then I want to save this image into my sql servier 2008 r2 database. I want to convert that string to varbinary.

my question

how to convert string to varbinary

Thank you

namero999 · Accepted Answer · 2013-06-04 12:53:27Z

1

JDBC maps varbinary to byte arrays. So this means that you first have to convert your base64 String to a byte array. This is what any Base64 implementation does. You just have to pick one.

With Apache Commons, for example, you would something like:

String myEncodedImage = "...";
byte[] myImage = Base64.decodeBase64(myEncodedImage);

And then you would simply pass that byte array to your persistency layer, JDBC will take care of the rest.

answered Jun 4, 2013 at 12:53

namero999

3,0121 gold badge20 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

java string to varbinary

background

my question

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

background

my question

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related