June 19, 2013

Post: Integers in PHP, running with scissors, and portability

… acknowledged and assigned. To summarize, if you need to unpack an unsigned 32bit int from binary stream, you have to: convert it to float or string manually, do that depending on int size… there’s no native 64-bit integer type in PHP. Let me remind that built-inint” might be 64-bit, but then again…

Post: PHP vs. BIGINT vs. float conversion caveat

… handling large numbers stored as float (especially on 32-bit systems where 32-bit int overflow will implicitly convert to float) and getting strange bugs…) helped in all cases. However at the moment the option is neither mentioned in the online documentation, nor explained clearly in php.ini. So…

Post: Handling big result sets

… than handle the result in loop mysql_fetch_array (here I use PHP functions but they…varchar(39) default NULL, `f11` int(11) default NULL, `f12` float default NULL, `f13` int(11) default NULL, `f14` … used server needs to convert millions of values from int to the string and client has to do reverse …