Topic: FileType data truncation
When trying to attach a Word Document (docx) in a Windows XAMPP environment, the actual filetype realised is:
application/vnd.openxmlformats-officedocument.wordprocessingml.document which turns out to be 72.
The field size for the above in the attachments table is 60.
Also proper html decoding of the '"' character does not occur in the attachment insertion sql.