Multiple images' data in one field
Posted: Sun Jan 05, 2003 1:48 pm
Currently I'm working on a script for storing the binary information of images for news stories in a database (as opposed to a directory). I'm wanting to be able to store multiple images in one field in the table (BLOB vartype, MySQL database). My idea would be to set a form of pipes to be able to parse off the images... i.e.
imagedata<PIPE>imagedata<PIPE>imagedata
And have <PIPE> be some specific spelling that wouldn't naturally occur in an image's binary data.
Would this work? Is there any other way, without using a directory? I wish that MySQL had dynamic array creation support, but alas... it does not.
imagedata<PIPE>imagedata<PIPE>imagedata
And have <PIPE> be some specific spelling that wouldn't naturally occur in an image's binary data.
Would this work? Is there any other way, without using a directory? I wish that MySQL had dynamic array creation support, but alas... it does not.