CODEWITHSUNDEEP
javamysqlarraysblob
androidGuy
androidGuy

Reputation: 5643

Easiest way to convert a Blob into a byte array

what is the easiest way to convert a Blob into a byte array?I am using MYSQL and i want to convert a Blob datatype into a byte array.

Iam using java programming language:)

Upvotes: 56

Views: 159061

Answers (3)

Muhammed_G
Muhammed_G

Reputation: 492

You can also get bytes array from Blob instance by this way:

Blob myBlob = null;
byte[] bytes = myBlob.getBinaryStream().readAllBytes();

Upvotes: 0

Lukas Eder
Lukas Eder

Reputation: 220762

The easiest way is this.

byte[] bytes = resultSet.getBytes("my_field");

Upvotes: 61

Timothy Groote
Timothy Groote

Reputation: 8643

the mySql blob class has the following function :

blob.getBytes

use it like this:

//(assuming you have a ResultSet named RS)
Blob blob = rs.getBlob("SomeDatabaseField");

int blobLength = (int) blob.length();  
byte[] blobAsBytes = blob.getBytes(1, blobLength);

//release the blob and free up memory. (since JDBC 4.0)
blob.free();

Upvotes: 90

Related Questions