MySQL fieldtype mapping not equivalent with PostgreSQL's?

[jonwimp]

The mapping for data type "blob" in OFBiz translates to PostgreSQL's BYTEA and MySQL's BLOB.

While BYTEA has max length of 256^4 - 1, BLOB has 256^2 - 1. In PostgreSQL, entities like
VideoDataResource can hold around 4GB of data; in MySQL, it's barely 65KB.

PostgreSQL BYTEA: http://www.postgresql.org/docs/7.2/static/datatype-binary.html

MySQL BLOB: http://www.htmlite.com/mysql003.php

The fix is in /framework/entity/fieldtype/fieldtypemysql.xml . The correct equivalent in MySQL is
LONGBLOB, not BLOB.

It seems OFBiz was developed with PostgreSQL, not MySQL. Is it worthwhile for me to move OFBiz to
true compatibility with or support for MySQL? There are various other bugs related to
incompatibilities between OFBiz and MySQL, the XAPoolDatasource issue being one of them (in which
case, it's also a possible issue with MSSQL and many other decent RDBMSes).

Jonathon