Re: PHP integer limit and Oracle 8i sequences
| From: | thies at digicol dot de | Date: | Sat, 22 Jul 2000 09:10:03 +0000 |
| Subject: | Re: PHP integer limit and Oracle 8i sequences | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-1419@lists.php.net to get a copy of this message | ||
On Fri, Jul 21, 2000 at 05:22:56PM -0400, Fred M. Bulah wrote:
>
> Hello,
> I am using PHP 4 and Oracle 8i for a very large database and have a question
> regarding the use of Oracle sequences as keys to tables and accessing those
> tables by key.
>
> Oracle sequences are auto-generated integers whose upper limit is 10**38.
> How large can a PHP 4 integer variable be? In "Professional PHP
> Programming" it says that the range for integers is -2 billion to +2
> billion. This was version 3+. Has this changed? The obvious problem is
> that when a sequence passes 2 billion, PHP 4 will not be able to handle the
> primary key.
>
> Is this the case or is there a known workaround/solution?
everything that comes back from oracle is a string by
default! therefore you don't hit this problem.
tc
>
> Note: php.net says that the max size is OS dependent.
> I looked at snaps.php.net and couldn't find any information there.
>
> Thanks in advance.
--
Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!"
Digital Collections Phone +49 40 235350 Fax +49 40 23535180
Hammerbrookstr. 93 20097 Hamburg / Germany