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

3903
3
06-02-2015 09:16 AM
847396730
Occasional Contributor III

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
Occasional Contributor III

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
Frequent Contributor

Are there values in the fields?

0 Kudos
bsneller_esrinederland
New Contributor II

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

0 Kudos