I read that MySQL has binary safe blobs, but PostgreSQL does not.
So far what I've found suggests that "binary safe" is something that really relates to functions and handling of data, not the data itself. It seems that the difference is that MySQL natively has ways of storing and manipulating blobs without having to specify data formatting, but PostgreSQL requires using either "quoted-printable
encodings" or "base64" encoding for binary data.
Is that all there is to it? What else should I worry about with respect to the differences between MySQL and PostgreSQL in the handling of blobs? I'm starting a new project, not migrating data, so I'm just wondering if there are particular reasons to choose one or the other with respect to their handling of binary blobs.