Brian,
What do people think about declaring a mime/type for blobs? What about storing a mime/type with each insert of blob?
Firebird has types for blobs in two ranges - one for system defined types, one for user defined types. The types are used by "filters" which are programmed objects like user defined functions that convert one type to another. For example, a filter might turn a text blob into HTML or vice-versa. In Firebird, procedures are stored in a byte-code format called BLR - system built filters convert BLR to a pretty-printed text format that is (somewhat) possible for a human to read. Storing the blob type in a user defined field allows the application to invoke similar filters in the application ... Storing in in the blob allows such functions to be moved into the database. There are arguments for both, but only storing the type in a location known to the system allows for system handling. Best, Ann _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
