Re: Extremely Large Numbers for MySQL column

2002-04-16 Thread Keith C. Ivey
On 16 Apr 2002, at 13:25, Chris Stark wrote: > SELECT * FROM results WHERE result_value < 2.8E-50 > > Anyway, I cannot seem to find a column type that is large enough to store > this kind of number. Have you tried DOUBLE PRECISION? It doesn't seem to be specified on the MySQL site, but Paul Du

Extremely Large Numbers for MySQL column

2002-04-16 Thread Chris Stark
Hello, I have a question, and hopefully someone out there can help me out. I have a lot of really large numbers (or should I say small, large in size ) that I need to store in my MySQL database. Numbers like: 2.8E-50 or 0.049zeros028 Anyway, I need to store these numbe