And there is not much point in sorting Office Documents or pictures by their binary representation either. Indexing such lengthy data would be insane. Theoretically the size of an OLE Object can be up to 1 GB. Can you sort the data in OLE Object column? – For the third time: No!.Can you create any index on an OLE Object column? – No, again.Can the Jet-/ACE-DB-Engine enforce uniqueness of the data in an OLE Object column? – No, sorry, it can’t.If you hear “ key” in a database related context, you should immediately think of some possible implications. So of course we can just store our binary keys in an OLE Object column. So what now?ĭespite its name, OLE Object is primarily a data type to store binary data any binary data. However, sometimes you might be dealing with binary data, which is not any sort of document/file, but rather a short binary key. You use the OLE Object (OLE = Object Linking and Embedding) data type to store this kind of data in an Access table. If the binary data in question is a file like a picture, PDF or an Office document, this is no problem at all. ![]() Now and then you want to store binary data in your Microsoft Access database. ![]() Exclusively licensed to, all rights reserved. Sort and index binary data in an Access databaseīy Philipp Stiefel, originally published August 23rd, 2016
0 Comments
Leave a Reply. |