RES: [Bioperl-l] Mysql columns and Blast evalues
skirov at utk.edu
Thu Mar 10 08:21:28 EST 2005
I think it should work OK. And I think the values you want to store are
too small for float (53 is the smallest: you should use float(53,53),
which defines both storage and display precision).
I am personally using Oracle so it is a differnt game. One thing you can
do is store the exponent, even just as an integer:
and store it as float.
When you want to work with the number again:
>Thanks for the tips !
>I guess the problem of using VARCHAR could be the limitations to compare the real evalues, so if I want to do something or only show evalues greater or smaller than 1e-50 would it work ok ?
>I wonder to know what other (mysql) column types (any further details would be appreciated) colleagues are using to store their Blast evalues ?
>De: Stefan Kirov [mailto:skirov at utk.edu]
>Enviada: qui 10/3/2005 00:25
>Cc: bioperl-l at portal.open-bio.org
>Assunto: Re: [Bioperl-l] Mysql columns and Blast evalues
More information about the Bioperl-l