Bug #14278 Updated: % and / bug with INTEGERs!

ID: 14278 Updated by: php-bugs@lists.php.net Reported By: pumuckel@metropolis.de -Status: Feedback +Status: No Feedback Bug Type: OCI8 related Operating System: Linux 2.2.19 PHP Version: 4.0.6 New Comment: No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". Previous Comments: ------------------------------------------------------------------------ [2002-04-13 09:02:35] thies@php.net oops - closed to fast. please send me a short _SELF_ contains script that shows the problem (including the oci-calls) ------------------------------------------------------------------------ [2002-04-13 09:00:59] thies@php.net all scalar values returned from PHP-OCI8 are strings. ------------------------------------------------------------------------ [2002-04-09 18:12:39] jimw@php.net recategorizing as an oci8 issue. ------------------------------------------------------------------------ [2002-01-09 09:17:14] pumuckel@metropolis.de After some more investigation on this bug I noticed following: I have an OCI insert statement executed with a 'RETURNING INTO' clause. The value which is returned is a oracle DB entry of type NUMBER. I expected to have the returned value in PHP to be a number as well. BUT it is a string! Some more output I produced in my script is: <? echo("$num (type: ".gettype($num)."[".strlen($num)."] - ".($num*1).")"); ?> The result (when the error occures): 106851 (type: string[6] - 1068514) As you can see the value of the $num variable changes while automatic type casting from string to int is executed. The reason for the NEW (bigger) value is possibly a not null terminated string value returned by the OCI interface. My suggestion: While typecasting from string to int an extra check should be done (e.g. detect if there is a null terminated string and if not: terminate it). Thanks for your patch! ------------------------------------------------------------------------ [2001-12-20 12:48:09] sander@php.net No feedback. Closing. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/14278 -- Edit this bug report at http://bugs.php.net/?id=14278&edit=1