I need to add a binary field to an existing database. It will typically hold 3-4 kB of data per record. I can't decide which to use, VBinary or VBlob. Which do you think would be more efficient, i.e. size?
I was just asking to be sure the docs were correct, because in your first reply you said the limit was 2044. Yes, I understand it's a hard limit. Thanks for clarifying that.
This type of field can effectively store binary values (i.e. values that contain zero-bytes inside) of variable size with limit up to 4088 bytes per value.