How to select a LONGBLOB from a table, convert to legible text ( ? )
This is a discussion on How to select a LONGBLOB from a table, convert to legible text ( ? ) within the MySQL forums, part of the Database Server Software category; --> Hi out there, just wondering if anyone has done this before. I have a table that upon select * ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
03-17-2008, 06:13 AM
| ||||
| ||||
 How to select a LONGBLOB from a table, convert to legible text ( ? ) Hi out there, just wondering if anyone has done this before. I have a table that upon select * shows in one LONGBLOB column this example data value (blob). How can select the column and return legible text ? Thank you, Jack      |
|
03-17-2008, 06:13 AM
| ||||
| ||||
| Re: How to select a LONGBLOB from a table, convert to legible text ( ? ) On Wed, 12 Mar 2008 21:18:30 +0100, Jack <jack_posemsky@yahoo.com> wrote: > Hi out there, just wondering if anyone has done this before. I have a > table that upon select * shows in one LONGBLOB column this example > data value (blob). > > How can select the column and return legible text ? It should just return the data, it that's regular text, so be it. What kind of interface are you using? Perhaps some CONVERT or CAST might be needed to give it a little nudge. -- Rik Wasmus |
Linear Mode
