[rt-devel] RT2 - longblob Curiosity
Michael Tratz [ml-mails]
mlist-mail at Esosoft.net
Fri Jun 29 18:27:28 EDT 2001
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?
More information about the Rt-devel