From: liyong at nenu dot edu dot cn
Operating system: Win2K
PHP version: 5.0.4
PHP Bug Type: MSSQL related
Bug description: Stored procedure can not return a data typed varchar more
than 255 bytes
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 bug report at http://bugs.php.net/?id=32582&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=32582&r=trysnapshot4
Try a CVS snapshot (php5.0):
http://bugs.php.net/fix.php?id=32582&r=trysnapshot50
Try a CVS snapshot (php5.1):
http://bugs.php.net/fix.php?id=32582&r=trysnapshot51
Fixed in CVS: http://bugs.php.net/fix.php?id=32582&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=32582&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=32582&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=32582&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=32582&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=32582&r=support
Expected behavior: http://bugs.php.net/fix.php?id=32582&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=32582&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=32582&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=32582&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=32582&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=32582&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=32582&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=32582&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=32582&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=32582&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=32582&r=mysqlcfg
