开发者

Find the size of OLE/binary data in MSAccess DB

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜