Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2014
    Posts
    8

    Unanswered: BLOB to human readable?

    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 strings, integers, floats, etc 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. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I'd suggest the best way is to not store the simple data in a blob in the first place.
    George
    Home | Blog

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    EAV designs will nearly always bite you in the ass. they are fine for certain applications but not general usasge
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •