I have changed the Content and Headers columns in the Attachments table
from longblob
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
case-insensitive BLOB.
<<<<
The RT developers are extremely clever and I’m sure there was a very
good reason that the columns were set to longblob.
I can’t remember anything off the top of my head, actually.
I’ll try to investigate this and see if there’s a good reason to change and
what the impact on existing sites would be.
-jOn Sat, Jun 30, 2001 at 12:27:28AM +0200, Michael Tratz [ml-mails] wrote:
Hi,
I have changed the Content and Headers columns in the Attachments table
from longblob
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
case-insensitive BLOB.
<<<<
The RT developers are extremely clever and I’m sure there was a very
good reason that the columns were set to longblob.