开发者

Find the size of OLE/binary data in MSAccess DB

开发者 https://www.devze.com 2022-12-08 09:18 出处:网络
I am trying to find a function in MSAccess that can be used to return the size of data (in bytes). e.g something like

I am trying to find a function in MSAccess that can be used to return the size of data (in bytes). e.g something like

SELECT x.id, sizeof(x.custom_data) AS size

Specifically for OLE data types b开发者_JS百科ut anything more general would be cool.


I think that what you are going to want to look at is the ADO Stream object. This data type has a Size property. Here is another link that shows some more of the methods and properties of this data type. Note that you will need to have a reference set to the Microsoft ActiveX Data Objects 2.5 Object Library as specified on the Microsoft page.

0

精彩评论

暂无评论...
验证码 换一张
取 消