June 19, 2013

Post: PHP vs. BIGINT vs. float conversion caveat

…identifiers are not enough and you have to use BIGINT 64-bit ids; e.g. if you are encoding… trick is that PHP floats are in fact doubles, i.e. double-precision 64-bit numbers. They have 52 …value handling: it can be used to workaround signed vs. unsigned int issues; it helps with float formatting; …

Comment: PHP vs. BIGINT vs. float conversion caveat

…MySQL Performance Blog wrote an interesting post today on PHP vs. BIGINT vs. float conversion caveatHere’s a quick excerpt Sometimes you need…-bit identifiers are not enough and you have to use BIGINT 64-bit ids; e.g. if you are encoding additional… day. The trick is that PHP floats are in fact doubles, i.e. double-precision 64-bit numbers. They [...]