MySQL and Gigawords help

Dennis Skinner dskinner at bluefrog.com
Tue Mar 21 17:51:48 CET 2006


Alan DeKok wrote:
>   Does MySQL have 64-bit support for fields?

If you need to store it as a number (ie do math on it within MySQL), it
can handle up to 63 bits (which may be enough for this purpose - you
have some big problems if users are transferring over 9.2 Exabytes of
data in 1 session).

You can always store numbers as text.

http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html

Look for BIGINT.

You may be able to go higher with a DOUBLE, but it may return it to you
in scientific notation.  I haven't played with that.

-- 
Dennis Skinner
Systems Administrator
BlueFrog Internet
http://www.bluefrog.com



More information about the Freeradius-Users mailing list