I think it must be that some DB's use blob's for the LONG_TEXT implementation and in those DB's the blob values don't allow default's.
I've put in an '||' clause for postgresql in the file. A bit of an architectural issue, so we'll have to review the DB driver structure if we do end up doing a full compatibility review in the future.