Select to view content in your preferred language

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

4215
3
06-02-2015 09:16 AM
847396730
Frequent Contributor

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

0 Kudos
3 Replies
847396730
Frequent Contributor

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!

0 Kudos
SepheFox
Deactivated User

Are there values in the fields?

0 Kudos
bsneller_esrinederland
Occasional Contributor

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

0 Kudos