What are the pro's and con's of using PostgreSQL vs MySQL for binary data?
That reference you link to is complete nonsense.  PostgreSQL supports binary data and binary-safe handling of data just fine.

There will be some small differences between MySQL and PostgreSQL about how the types and certain functions are named, but overall it won't make much difference.  There are probably other, better reasons for choosing one system over the other.