>>
>>I was using SQL passthru to put data into a remote database that was based on 'MySQL'. It seemed to require sending the data as text. When database receives command it converts the text back to binary and stores it. End result is it takes up same amount of space as original.
>
>This is quite interesting, and good to know in case I may need to do anything with MySql. When you retrieve a blob off such a table, does it also come as hex or as it was?

It comes back as it was. It comes back as a blob in Fox cursor, which can then be assigned to a string and then to a file.

*
** Retrieve PDF Blob
*
CURSORSETPROP("MapBinary",.T.,0)
CURSORSETPROP("MapVarchar",.T.,0)
lcQuery = ""
TEXT TO lcQuery TEXTMERGE NOSHOW 
	SELECT PDF FROM Disciplinary D WHERE D.DOC_Id = 2881
ENDTEXT 
SQLEXEC(hMySQL,lcQuery)
PDFRetrieve = SQLResult.PDF
STRTOFILE(PDFRetreive,"TestPDF.pdf",0)