Hi, I have one XML list stored as a Blob in MySql and I need to retrieve it as the original text. My actual DBI Model/Schema gets all text columns fine, but not the blob.
Maybe I can add some native mysql commands to the query to do the conversion, but I do not know where in the model o result set I can do such thing.
In case you wonder why I have this situation: my first real Catalyst project is porting a working Flex site. Not too complicated. But in Flex I access database through a simple custom .php interface, and I get the Blob column as text without any special treatment.
I can't change the blob to text because customers are using it. Maybe in a second version.
Regards from the apprentice village, dear monks</>