int8 and PHP problems
am 19.12.2003 15:42:55 von CSeaderI have a database with two int8 fields that don't seem to be working proper=
ly. I want it too be able to store the values of 0x000000000002, but it won=
't. MySQL seems too. Strange. PHP does not handle 64 bit integers so that w=
ill not work either. How can i deal with this kind of value useing PHP and =
PostgreSQL.
One Reply i had made sense, but not sure how to do it.
You are apparently trying to insert a hex string "0x000000000002"=20
>(notice it starts with '0x') into an int8 field -- don't do that.=20
>Convert the hex to integer before inserting, or cast it, like so:
>regression=3D# select x'000000000002'::int8;
How do you do the above casting as explained before inserting, or how do yo=
u convert it to an integer when PHP will not handle the 64 bit integers at =
all.=20
Can someone please help on this?
Thanks,
Cameron Seader
Operations Center Technician II
CSeader@Idahopower.com
1.208.388.2582 Office
[INFO] -- Access Manager:
This transmission may contain information that is privileged, confidential =
and/or exempt from disclosure under applicable law. If you are not the int=
ended recipient, you are hereby notified that any disclosure, copying, dist=
ribution, or use of the information contained herein (including any relianc=
e thereon) is STRICTLY PROHIBITED. If you received this transmission in err=
or, please immediately contact the sender and destroy the material in its e=
ntirety, whether in electronic or hard copy format. Thank you. A2
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings