4
The type of data DOUBLE is a 64-bit floating point, but can be used on 32-bit systems without any problem?
1 answer
5
It is possible, they are completely different things. That 32 bits indicates memory addressing capacity, that is, it reaches up to 4GB. We can say that is the size of the pointer or of word (roughly).
That 64 of double is the size of the number that can be stored in that type.
It’s just a coincidence that there’s a 64-bit type and a 64-bit architecture, there’s no relationship between these measurements. A 64-bit architecture can be more efficient to work with a type double.
Databases typically store data independently of the machine’s architecture so that it is portable between totally different computers and deliver in a way that architecture asks for.
Browser other questions tagged mysql typing double 64-bits 32-bits
You are not signed in. Login or sign up in order to post.
Your last edition was very enlightening. Thank you.
– Renan Cavalieri