John MacLerran ([log in to unmask]) wrote: : Hi Everyone, : I'm trying to find out if Allbase will support BLOBs (Binary Large : OBjects). We need to be able to store digitized images (JPeg or GIF : format) in a relational table for use in an ID-card system. I know that : both support varbinary and long varbinary columns, but I don't know if : that's the same as a BLOB or not. : We have G1.13 on an HP3000 and F0.48 on our HP9000, but we will soon be : upgrading that version to G1.13 (as soon as we get a valid installation : codeword from HP). : I'd be grateful for any information anyone has. : : ---------------------------------------------------------------------- : John MacLerran, IT Systems Analyst [log in to unmask] : Idaho State University (208) 236-2872 : http://www.isu.edu/~macljohn : ---------------------------------------------------------------------- Use a long varbinary. We've been doing that for > 5 years (compressed tarfiles of word processing documents containing graphics). Check the behavior if you exceed the max size - it used to truncate which destroys your data - the constraint wasn't working. -- Dan Mercer Reply To: [log in to unmask] Opinions expressed herein are my own and may not represent those of my employer.