Proplems with MySql BLOB in Cold Fusion

Hi
I am working on my first project with MySql. When I query the database in Cold Fusion all the results from the BLOB fields are returned as numbers even though if I look at the data in the database it is still text.

The same query made on an Access memo field works perfectly. Does anyone have an idea sa to what I'm doing wrong?

Thanks

In the CF Administrator, do you have the check box checked for "Enable binary large object retrieval (BLOB)."?

Is so, then you may well be getting the binary data correctly. Remember that BLOB stands for BINARY Largo Object. That means the data is stored in binary format. This is not like a Memo field in Acess which is simply a large character field. You might need to play with various CF functions like toString() to format the data properly. Try:

<CFSCRIPT>
writeOutput(toString(GetBLOB.blobFieldName));
</cfscript>