Database column type of payload should be VARBINARY, not BINARY

[lbilger]

Steps to reproduce

• Library version: 1.1.0
• JDK version: irrelevant
• Operating system: irrelevant
• Complete executable reproducer: n/a
• Steps: n/a

The type of the payload column in the database table is currently BINARY (in the MyBatis mapper as well as the DDL in the examples), which is a fixed-length data type. This will take up the maximum space for every row, even if the payload is smaller than that. We should use VARBINARY instead.

Workaround: I haven't tried yet, but I think it should be possible to just use VARBINARY in the actual database table, so this is mainly an issue with the examples.

[zambrovski]

Have you tried?

[lbilger]

Yes, I changed it to VARBINARY(MAX) for one of our apps and it seems to work.