|  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
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Bug Type:
From: nektarin at me dot com
New email:
PHP Version: OS:


 [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: Wed Oct 28 18:01:24 2020 UTC