Another BLOB question
I'm not a C++ guy, but I've managed to rescue my data from a little (orphaned) app that used an inline sqlite db. I've got my data into MySql and corrected all of the little things (autoincrement > auto_increment). But the BLOBs are throwing me.
in MySql queries, the BLOB columns return as the word BLOB instead of the data (it's a reference tool, so the information is all text no images, probably some html formatting code).
In DW3 with WA DataAssist I get an unspecified dB error on every table that a BLOB datatype.
I would have built the initial product differently too, but it is what it is. There are over 2200 records. I just want to rescue my data and get into a form I can use.
Any ideas? References?