0

I store "BYTE[]" type data into a BLOB. It stores it perfectly, the data being represented by hexadecimal pairs when I try to view it in MySQL. Now I want to convert that hexadecimal pairs into string. All the data is "simple" data such as strsing, intesger, floats, e the only thing that it is represented in hex. There is no complex data structures inside the BLOB.

What is the best way to do this?

Thank you

2
Contributors
2
Replies
6
Views
3 Years
Discussion Span
Last Post by riahc3
0

Unserealizing the BLOB byte data would be done in a program, probably just like you turned it into bytes in the first place.

I don't think there is a way of doing this directly in the database, and if so, we would like to know what type of database you are using.

0

Unserealizing the BLOB byte data would be done in a program, probably just like you turned it into bytes in the first place. I don't think there is a way of doing this directly in the database, and if so, we would like to know what type of database you are using.

Well, if it couldnt be done in the database, using MySQL Workbench, why when I right click and click "Open Value in Editor" it perfectly shows me the hexadecimal numbers? It would just need to get those hexadecimal numbers shown in a select, convert it using unhex and I would have a (huge) string with the in a human readable format data I want.

Just not sure how to do it.

Im using MySQL 5.6 if that was your question.

Thank you for the reply.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.