[MySQL] Wrong type on column structure

[rodehoed]

DS files stored in DB get truncated (at 65535 bytes) because the field is defined as a BLOB instead of a BINARY. It's about:

• table: scaptimony_scap_contents
• field: scap_file

This seems not be the issue on PG databases. I have checked the other scaptimony column structures and I could not find other problematic types.

[rodehoed]

Work-around:

ALTER TABLE scaptimony_scap_contents MODIFY COLUMN scap_file LONGBLOB;

Seems to fix stuff 👍

[rodehoed]

Also found:

• table: scaptimony_arf_report_raws
• field: bzip_data

[isimluk]

Thanks for report!