ID:               32582
 User updated by:  liyong at nenu dot edu dot cn
 Reported By:      liyong at nenu dot edu dot cn
 Status:           Open
 Bug Type:         MSSQL related
 Operating System: Win2K
-PHP Version:      5.0.4
+PHP Version:      5.0.3
 New Comment:

sorry,it's 5.0.3,not 5.0.4


Previous Comments:
------------------------------------------------------------------------

[2005-04-05 04:57:38] liyong at nenu dot edu dot cn

this problem is also scripted at
http://www.nb321.com/phppost4/php34086.htm

------------------------------------------------------------------------

[2005-04-05 04:52:21] 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


------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=32582&edit=1

Reply via email to