ID: 5642 Updated by: [EMAIL PROTECTED] Reported By: jnguyen at scrtec dot org -Status: Closed +Status: Bogus -Bug Type: Oracle related +Bug Type: OCI8 related Operating System: Digital UNIX V5.0 (Rev. 910) PHP Version: 4.0 Release Candidate 2
Previous Comments: ------------------------------------------------------------------------ [2000-08-25 05:48:21] [EMAIL PROTECTED] php does _not_ touch the string you pass to oracle - please make sure your NLS_LANG environment is set correct in your apache process. ------------------------------------------------------------------------ [2000-08-23 08:12:05] [EMAIL PROTECTED] Is this still happening with more recent versions of php4 (from CVS or snapshot from http://snaps.php.net/ ) ?? --Jani ------------------------------------------------------------------------ [2000-07-17 12:35:31] jnguyen at scrtec dot org $sql1 = "SELECT id, the_date FROM a_table WHERE the_date < to_date('01-JAN-99')"; $stmt = OCIparse($conn, $sql1); OCIexecute($stmt); while(OCIfetch($stmt)) { ... } The PHP script above returns everything, including records newer than 01-JAN-99, from the table, whereas when I cut and paste the SQL statement into SQL*PLUS, the correct number of results is fetched. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=5642&edit=1
