I have a database with two int8 fields that don't seem to be working properly. I want it too be able to store the
valuesof 0x000000000002, but it won't. MySQL seems too. Strange. PHP does not handle 64 bit integers so that will not
workeither. 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"
>(notice it starts with '0x') into an int8 field -- don't do that.
>Convert the hex to integer before inserting, or cast it, like so:
>regression=# select x'000000000002'::int8;
How do you do the above casting as explained before inserting, or how do you convert it to an integer when PHP will not
handlethe 64 bit integers at all.
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
applicablelaw. If you are not the intended recipient, you are hereby notified that any disclosure, copying,
distribution,or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you
receivedthis transmission in error, please immediately contact the sender and destroy the material in its entirety,
whetherin electronic or hard copy format. Thank you. A2