topic Re: What unit does an Attachment table's DATA_SIZE field use? in Data Management Questions

What unit does an Attachment table's DATA_SIZE field use?

Anonymous User — Tue, 02 Jun 2015 16:16:01 GMT

I am troubleshooting an issue I suspect is related to database size. After enabling Attachments on a feature class, there is a resultant table called FeatureClassName_attach, and that table contains a field called DATA_SIZE. What unit is this field in? No matter what unit I guess, the result seems crazy, and I can't find a definitive answer in the documentation.

Thanks!

DT10.2.2, SQL Server 2008R2, SDE gdb 10 & 10.2.2

Re: What unit does an Attachment table's DATA_SIZE field use?

Anonymous User — Wed, 03 Jun 2015 00:38:55 GMT

I'm going to say it's bytes. Although I confirmed with IT that the database settings are indeed generous and could support absurdly large records, logic suggests these must be bytes.

I would welcome any recommendations on how to confirm.

Thanks!

Re: What unit does an Attachment table's DATA_SIZE field use?

SepheFox — Wed, 03 Jun 2015 00:54:11 GMT

Are there values in the fields?

Re: What unit does an Attachment table's DATA_SIZE field use?

bsneller_esrinederland — Mon, 15 Jan 2024 06:31:12 GMT

I attached a JPG to a feature and compared the value and the size on disk: indeed DATA_SIZE is in Bytes