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

go to bug id or search bugs for

Bug #32582 Stored procedure can not return a data typed varchar more than 255 bytes
Submitted: 2005-04-05 04:52 UTC Modified: 2005-04-05 05:39 UTC
From: liyong at nenu dot edu dot cn Assigned:
Status: Not a bug Package: MSSQL related
PHP Version: 5.0.3 OS: Win2K
Private report: No CVE-ID: None
View Developer Edit
 [2005-04-05 04:52 UTC] liyong at nenu dot edu dot cn 
Description:
------------
I want return varchar(600) from stored procedure,but it is shortened to 255 bytes.



Reproduce code:
---------------
stored procedure:
create procedure p_bug 
@msg varchar(600) output
as 
 set @msg='something more than 255 bytes ......'


PHP statement:
$stmt=mssql_init('p_bug');
mssql_bind($stmt,"@msg",&$msg,SQLVARCHAR,TRUE); 
$result=mssql_execute($stmt);
echo $msg;

Expected result:
----------------
something more than 255 bytes ......

Actual result:
--------------
something shortened to 255 bytes

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-04-05 04:57 UTC] liyong at nenu dot edu dot cn 
this problem is also scripted at http://www.nb321.com/phppost4/php34086.htm
 [2005-04-05 05:05 UTC] liyong at nenu dot edu dot cn 
sorry,it's 5.0.3,not 5.0.4
 [2005-04-05 05:39 UTC] fmk@php.net 
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.php.net/manual/ and the instructions on how to report
a bug at http://bugs.php.net/how-to-report.php

The dblib library from Microsoft used to generate the MSSQL extension on Windows has not been updated since SQL Server 6.5. It's not possible to to fix this problem with Microsofts library.

Use text type to return values longer than 255 bytes.

I have a test version of php_dblib.dll available on my home page (http://kromann.info/php.php). So far it's only available for php 5.1. It uses FreeTDS where the limmitations from the MS Library has been fixed. All functions names are still mssql_* so it's a very simple replacement
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Wed Jan 15 03:01:28 2025 UTC