Tested and recommended database settings for RHDG String-keyed-jdbc-store persistence

Issue

• What column types are recommended for persistence with string-keyed-jdbc-store?
• The cache can not load entries from a string-keyed-jdbc-store using MYSQL with data type BINARY. (Note the ERROR can be slightly different based on the version or configuration)

ERROR [org.infinispan.interceptors.impl.InvocationContextInterceptor] ISPN000136: Error executing command GetKeyValueCommand on Cache 'db', writing keys [] org.infinispan.persistence.spi.PersistenceException: I/O error while unmarshalling from stream
    at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.unmarshall(JdbcStringBasedStore.java:777)
    ...
Caused by: protostream.com.google.protobuf.InvalidProtocolBufferException: Protocol message contained an invalid tag (zero).
    at protostream.com.google.protobuf.InvalidProtocolBufferException.invalidTag(InvalidProtocolBufferException.java:105)
    ...

• The cache can not store entries to a string-keyed-jdbc-store. (Note the ERROR can be slightly different based on the database)

ERROR [org.infinispan.server.hotrod.BaseRequestProcessor] ISPN005003: Exception reported org.infinispan.persistence.spi.PersistenceException: Error while storing string key to database; key: 'WrappedByteArray[\J05\t\e\s\t\1 (7 bytes)]'
    at org.infinispan.persistence.jdbc.common.impl.BaseJdbcStore.lambda$write$4(BaseJdbcStore.java:149)
    ...
Caused by: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'DATA_COLUMN' at row 1
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:104)
        ...