Brian Aker wrote: > Hi! > > Is VARBINARY useful? > > You can have a 64K binary object that we will sort based on the bits. It > does mean you could look up a record via another one... though that > would be pretty expensive compared to just using a precomputed MD5. > > The saving grace of this thing is if you didn't want UTF8 you could just > use it.. though the sort would be all FUBAR because of case.
Use a BLOB instead. IIRC, it can already sort on a prefix of the BLOB, but with none of the restrictions on the size of the object. Just my few cents, Mats Kindahl > > Cheers, > -Brian > > -- > _______________________________________________________ > Brian "Krow" Aker, brian at tangent.org > Seattle, Washington > http://krow.net/ <-- Me > http://tangent.org/ <-- Software > _______________________________________________________ > You can't grep a dead tree. > > > > > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp -- Mats Kindahl Lead Software Developer Replication Team MySQL AB, www.mysql.com
begin:vcard fn:Mats Kindahl n:Kindahl;Mats org:Sun Microsystems adr;quoted-printable:;;Tegv=C3=A4gen 3;Storvreta;SE;74334;Sweden email;internet:[EMAIL PROTECTED] title:Lead Replication Software Developer x-mozilla-html:FALSE version:2.1 end:vcard
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
