|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Doc Bug #45732 odbc.defaultlrl = 0 insufficiently documented
Submitted: 2008-08-06 12:12 UTC Modified: 2020-10-05 20:57 UTC
Avg. Score:4.0 ± 0.9
Reproduced:8 of 8 (100.0%)
Same Version:5 (62.5%)
Same OS:2 (25.0%)
From: nektarin at me dot com Assigned: cmb (profile)
Status: Closed Package: ODBC related
PHP Version: 5.2.6 OS: Windows
Private report: No CVE-ID: None
 [2008-08-06 12:12 UTC] nektarin at me dot com
The information given in php.ini is wrong.

Setting "odbc.defaultlrl = 0" is not the same as Passthru (as described 
in php.ini).
To use passthru you have to comment the line containing odbc.defaultlrl.

Reproduce code:
odbc.defaultlrl = 0

Expected result:
odbc.defaultlrl = PASSTHRU

Actual result:
odbc.defaultlrl = 0 (0 bytes is received for every SQL query)


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2008-09-10 19:59 UTC] blabounty at minnetronix dot com
Testing this using an ODBC connection to MS SQL SERVER 2005, commenting out the line causes text fields, when queried through an ODBC connection, to cut off at 4096 characters.

They do indeed cut off at 0 when the setting is set to 0, however.

I'm using a Windows XP 32-bit Zend Core platform, but I've also tested this on a non-Zend Apache server and the result is the same.
 [2020-10-05 20:57 UTC]
-Summary: odbc.defaultlrl = 0 != Passthru +Summary: odbc.defaultlrl = 0 insufficiently documented -Status: Open +Status: Verified -Type: Bug +Type: Documentation Problem -Assigned To: +Assigned To: cmb
 [2020-10-05 20:57 UTC]
That is how it is meant to behave.  "passthru" means that LONG and
LONGVARBINARY column data are directly printed when retrieved via
odbc_result(), instead of being returned as string.

Apparently, the docs can be improved in this regard.
 [2020-10-06 10:18 UTC]
Automatic comment on behalf of cmb
Log: Fix #45732: odbc.defaultlrl = 0 insufficiently documented
 [2020-10-06 10:18 UTC]
-Status: Verified +Status: Closed
PHP Copyright © 2001-2020 The PHP Group
All rights reserved.
Last updated: Sat Oct 24 21:01:24 2020 UTC