php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Doc Bug #45732 odbc.defaultlrl = 0 insufficiently documented
Submitted: 2008-08-06 12:12 UTC Modified: 2020-10-05 20:57 UTC
Votes:8
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 Developer Edit
 [2008-08-06 12:12 UTC] nektarin at me dot com 
Description:
------------
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)

Patches

Pull Requests

History

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] cmb@php.net
-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] cmb@php.net 
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] phpdocbot@php.net 
Automatic comment on behalf of cmb
Revision: http://git.php.net/?p=doc/en.git;a=commit;h=df4203dcc5762f0570852ec4e1adc8ed8b0fc252
Log: Fix #45732: odbc.defaultlrl = 0 insufficiently documented
 [2020-10-06 10:18 UTC] phpdocbot@php.net
-Status: Verified +Status: Closed
 [2020-12-30 11:58 UTC] nikic@php.net 
Automatic comment on behalf of mumumu
Revision: http://git.php.net/?p=doc/ja.git;a=commit;h=2d0373a6ab06ab81f7ff21bbef9e1fade50e8864
Log: Fix #45732: odbc.defaultlrl = 0 insufficiently documented
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Sun Jul 06 00:01:34 2025 UTC