> -----Original Message----- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite- > users-bounces at mailinglists.sqlite.org] On Behalf Of Eric Hill > Sent: Saturday, May 09, 2015 2:14 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Please confirm what I THINK I know about blobs > > The comment approach could work, I guess, but why not just encode the > type into the column's declared type? > > CREATE TABLE blob_table ( > ModelNo TEXT, > SerialNo TEXT, > VSWR BLOB_DOUBLE > ) > > That's what I do with numeric columns that I need to identify as > actually containing dates. As I understand it, SQLite only scans those > type names to choose a column affinity, so you are free to be as > creative with them as you want. sqlite3_column_decltype() will return > whatever you put as the type. >
Best idea yet! Anyone see any issues with this? -- Bill Drago Senior Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / William.Drago at L-3COM.com > HTH, > > Eric CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any attachments are solely for the use of the addressee and may contain information that is privileged or confidential. Any disclosure, use or distribution of the information contained herein is prohibited. In the event this e-mail contains technical data within the definition of the International Traffic in Arms Regulations or Export Administration Regulations, it is subject to the export control laws of the U.S.Government. The recipient should check this e-mail and any attachments for the presence of viruses as L-3 does not accept any liability associated with the transmission of this e-mail. If you have received this communication in error, please notify the sender by reply e-mail and immediately delete this message and any attachments.
