21 Mar
2006
21 Mar
'06
11:51 a.m.
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