#32582 [Opn]: Stored procedure can not return a data typed varchar more than 255 bytes
| From: | liyong at nenu dot edu dot cn | Date: | Tue, 05 Apr 2005 02:57:38 +0000 |
| Subject: | #32582 [Opn]: Stored procedure can not return a data typed varchar more than 255 bytes | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-76345@lists.php.net to get a copy of this message | ||
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
New Comment:
this problem is also scripted at
http://www.nb321.com/phppost4/php34086.htm
Previous Comments:
------------------------------------------------------------------------
[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