How To Check Images with Zero Bytes in Size on BLOB column datatype [message #638563] |
Mon, 15 June 2015 08:04 |
wtolentino
Messages: 398 Registered: March 2005
|
Senior Member |
|
|
we have this table that has a column blob datatype. the values that we stored in the column is images mostly in .tiff format. they are data feeds coming from another agency that we store for our applications. the problem is some of them are zero bytes. is there a way to check their size? we need to determine which rows has a images that has zero bytes so we can correct them. thanks.
|
|
|
|
|
|
|
|
|
Re: How To Check Images with Zero Bytes in Size on BLOB column datatype [message #638579 is a reply to message #638570] |
Mon, 15 June 2015 09:17 |
wtolentino
Messages: 398 Registered: March 2005
|
Senior Member |
|
|
as of now we do not have codes to programmatically differentiate a null file and zero byte file. the issue is that when we open the image on our apps there was nothing on it. when we download it there is a file however the size is zero.
for example:
R:\>dir 2*.tiff
Volume in drive R is dot_home
Volume Serial Number is 009A-9A03
Directory of R:\
06/15/2015 10:15 AM 0 21352455.tiff
1 File(s) 0 bytes
0 Dir(s) 45,057,359,380,480 bytes free
R:\>
|
|
|
|
|