Hello. If you want the meat, go to "The Problem"
I'll try to be a straightforward as possible. I am migrating a SQL 7 database into MySQL. Everything works except for one table with a MEDIUMBLOB type.
To explain: this database is a bunch of products. One particular table has the product ID & image (stored within the DB as binary).
SQL 7 refuses, by ODBC, to transfer these fields into the MySQL database either citing that blob entries can not be inserted using a query or that the source buffer's too small.
For the time being I've decided to export the table into a text file.
I have a text file that is tab delimited, rows separated by \n, optionally " contained. One of the fields in the dataset is binary. SQL 7 has it stored as one big string of hexidecimal code.
If, for example, I put in db.tbl.image=0x[string], it will convert the string to hex and insert the binary code properly. ([string] would be any one of the strings from a given row in the file)
What I want to know is, how can I load a whole table, including this one troublesome binary filed (stored as HEX) into the database given that I have about 2000 rows?
/*So far I can load the file into the database, but I cannot get MySQL to realize that the hex codes are not text. MySQL just assumes the field is text and I can't get past this. */
How can I transfer 2000 binary fields from SQL 7 to MySQL without it giving me one of the following messages:
-Query-based insertion of Blob entries is not supported
-Error at source: buffer not large enough
(exact error messages can be provided)
Any suggestions??? I have no idea how to solve this, it's killing me..