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?
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.
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.