note 87374 added to function.mssql-bind
| From: | (siemens) | Date: | Tue, 02 Dec 2008 13:49:53 +0000 |
| Subject: | note 87374 added to function.mssql-bind | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-147520@lists.php.net to get a copy of this message | ||
VARCHAR length problem.
I used to have a varchar field in the DB with a length of 900. I tried many things but there was no
way for PHP to set (and also to read!) a field of more than 255 chars.
I modified my DB: instead of VARCHAR I now use TEXT in this field, also updated my stored procedure
definitions, and my mssql_bind() statements:
mssql_bind($stmt, "@memo1d", $_POST["r_Memo1D"], SQLTEXT);
Still, there is a limit at approx 4090 but that is enough for me.
----
Server IP: 217.13.201.10
Probable Submitter: 193.158.17.135
----
Manual Page -- http://www.php.net/manual/en/function.mssql-bind.php
Edit -- https://master.php.net/note/edit/87374
Del: integrated -- https://master.php.net/note/delete/87374/integrated
Del: useless -- https://master.php.net/note/delete/87374/useless
Del: bad code -- https://master.php.net/note/delete/87374/bad+code
Del: spam -- https://master.php.net/note/delete/87374/spam
Del: non-english -- https://master.php.net/note/delete/87374/non-english
Del: in docs -- https://master.php.net/note/delete/87374/in+docs
Del: other reasons-- https://master.php.net/note/delete/87374
Reject -- https://master.php.net/note/reject/87374
Search -- https://master.php.net/manage/user-notes.php