I have changed the Content and Headers columns in the Attachments table
to longtext in order to facilitate case-insensitive searches.
Before making this change, I consulted the MySQL manual. It states:
The only difference between BLOB and TEXT types is that sorting and
comparison is performed in case-sensitive fashion for BLOB values and
case-insensitive fashion for TEXT values. In other words, a TEXT is a
The RT developers are extremely clever and I’m sure there was a very
good reason that the columns were set to longblob.
Anyone know why?