Posted by Henk verhoeven on 04/12/07 22:54

Hi david,

Maybe you could use CONV(`columnname`, 10, 10) in your SQL to convert
the integer to a string before it is passed to php.

for example if the colum holding 64 bits integers is named `theInt`:

SELECT id, CONV(theInt, 10, 10) FROM yourtable

would return the id and theInt columns but theInt converted to a string.

Once the string is in php you may use GMP functions for calculations
etc., see http://nl2.php.net/manual/en/ref.gmp.php

Success,

Henk Verhoeven,
www.phppeanuts.org.

David T. Ashley schreef:
> I have a box where I'm forced to use PHP before 64-bit integers became
> standard ...
>
> If I run a MySQL query where one of the fields returned is 64-bit integer,
> how do I get this into PHP as a string? My recollection is that in the
> result sets it "auto types" so that it is an integer, and 64-bit integers
> will cause problems if one tries to assign into 32 bits.
>
> P.S.--Once into PHP as a string, I would use the bcmath library to
> manipulate it ...

[Back to original message]