Am I missing something? I'm trying to return the size of the data contained in a varbinary(max) column, however it appears that the value being returned is double what it should be. Is this normal, or is there something else I need to do?
Thanks,
Devin
Edit: I'm not discounting that my data may be weird, but I wanted to cast my net as wide as possible.
Perhaps the field contains trailing blanks...|||Why do you think this is double? Can you post a snippet of code that doesn't seem to make sense? Like:
set nocount on
declare @.test varbinary(max)
set @.test = 0x12
select datalength(@.test)
set @.test = 0x1234
select datalength(@.test)
Returns:
--
1
--
2
|||Ignore this. I was using compression on the streams as I was putting them into the column. Apparently the framework's GZipStream class has a bug that causes it to mishandle files that already have compression in them (video, jpg, pdf) so that they end up larger.
DATALENGTH was reporting the correct size for the contents of the column.
Thanks,
Devin
