[rt-devel] RT2 - longblob Curiosity

Jesse jesse at fsck.com
Fri Jun 29 19:21:54 EDT 2001

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.


On 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.
> Anyone know why?
> Very curious,
> Michael Tratz
> _______________________________________________
> Rt-devel mailing list
> Rt-devel at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-devel

jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com 
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

. . . when not in doubt, get in doubt.  -- Old Discordian Proveb

More information about the Rt-devel mailing list