using blobs...

["Stephen Adler" <user=65@nabble.blu.org>]

 Hi Blu! (Happy Boston Marathon day...) 

I'm spending the day playing around with a DB schema in which I want to 
store word document files in blob fields in one of my tables. I want to 
test my db schema by issuing sql command at the mysql prompt. So the 
question I have, is how can I insert a .doc file into my database using 
the mysql command line interface? I've spotted a bunch of visual basic, 
C# and php examples of how to stuff a bunch of bits into the blob field, 
but they all seem to involve defining some large array in which the 
whole file was read into, then passing the pointer to the array in the 
values part of the insert statement. Does this mean that I have to write 
code in order to stuff bits into the field? 

Thanks in advance... 

Cheers. Steve. 




-- 
This message has been scanned for viruses and 
dangerous content by MailScanner, and is 
believed to be clean. 

_______________________________________________ 
Discuss mailing list 
[hidden email] 
http://lists.blu.org/mailman/listinfo/discuss