note 78769 added to ref.mssql
| From: | nospam at gmail dot com | Date: | Fri, 26 Oct 2007 18:10:00 +0000 |
| Subject: | note 78769 added to ref.mssql | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-131753@lists.php.net to get a copy of this message | ||
If you are using mssql_bind with stored procedures on Windows and need to get around the 255
character varchar limit, one hack is to pass SQLTEXT as the data type to mssql_bind rather than
SQLVARCHAR.
You will still need to use some means to get around returning varchar data that's longer than
255, the simplest of which is to CAST the varchar field as text in your stored procedure itself.
----
Server IP: 64.71.164.2
Probable Submitter: 74.94.159.146
----
Manual Page -- http://www.php.net/manual/en/ref.mssql.php
Edit -- https://master.php.net/note/edit/78769
Del: integrated -- https://master.php.net/note/delete/78769/integrated
Del: useless -- https://master.php.net/note/delete/78769/useless
Del: bad code -- https://master.php.net/note/delete/78769/bad+code
Del: spam -- https://master.php.net/note/delete/78769/spam
Del: non-english -- https://master.php.net/note/delete/78769/non-english
Del: in docs -- https://master.php.net/note/delete/78769/in+docs
Del: other reasons-- https://master.php.net/note/delete/78769
Reject -- https://master.php.net/note/reject/78769
Search -- https://master.php.net/manage/user-notes.php