SUBSTRING on a LONGBLOB

[David Perron]

Im trying to retreive the data from a LONGBLOB column but I have been unable
to convert the binary data back to character data.
Is there something Im not doing right with the query below?

SELECT changehistory.timestamp, SUBSTRING(changedata.changes,1,1000)
FROM changehistory, JOIN changedata ON changeid;