From: schneider <sch...@fr...> - 2005-04-27 21:02:07
|
Thank you for your reply. I am not such that I understand very well your explanation : my kownledge in mathematic is not very good (I am only an organic chemist ;-) ). Thus you cut the 1024 bit fingerprint in 16 fragments and you transform them into BitInt. But how can we find the information in these intergers without the inverse transformation ? Best regards, Jean-Marie Nina Jeliazkova wrote: >Hi, > >indeed, 16 fileds of MySQL type BigInt unsigned (unsigned is important) make >1024 bit fingerprint. 16 field is not that big disadvantage, having in mind >that prescreening can be done on the fly with a single SQL statement. > >Regards, >Nina > > >Stefan Kuhn <ste...@un...> wrote: > > > >>Hi, >>I'm indeed using MySQL's largest int type (not sure about the name just now) >> which is 64. 16 of these make the fingerprint. This is, I think, the >shortest > > >>possible way. Only disadvantage is that you need 16 fields. I also tried to >>use a string where every bit is used, but you then end up with control >>characters in the string and I could not fully control these. >>Stefan >> >> >> |