Hi all, I am curious why there is BLOB datatype that accepts HEX strings only.
HEX encoding requires twice as much space as original data, thus it is rather ineffective. Instead, base64 encoding with ASCII datatype seems more effective in terms of space, and I believe it doesn't impose noticeable performance penalty either. So, are there any special use cases for BLOBs, or should I give up on them and use ASCII + base64 for my binaries? Thanks in advance, Pavel.
