Accessing text data from mysql blob field

[thaimann]

I have some text data in a largeblob, the database is mysql 4.0.  How do I access it as text data.  In the MySQL library I use with delphi all I would have to do is


Var
   S: String
...

S := MyTable.FieldByName('MyBlob').AsString;