Andrew Maclean wrote: > Is there some underlying physical reason why postgresql and other > databases cannot handle binary data without going through all this > silly escape stuff which must have a massive impact on performance. Or > is it just because databases originally were built to handle just test > data?
What John said, but just a small note. The text representation of the various datatypes are fairly static. The binary representations can change - even between two databases with the same version number (floating-point vs big-int timestamps). For a meaningless (to the db) "blob" type that doesn't matter, but you will need to be aware of the issues and have appropriate tests in place for your application. -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
