mssql_bind question
| From: | David Stoltz | Date: | Mon, 09 Apr 2012 17:42:11 +0000 |
| Subject: | mssql_bind question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-317494@lists.php.net to get a copy of this message | ||
Folks,
Having a difficult time using mssql_bind with characters greater than
8000...the database field is set to ntext, and I've also tried
varchar(max), both seem to produce the same results:
If I use:
mssql_bind($stmt, '@mgrnotes',$mgrnotes,SQLVARCHAR,false,false,8000);
I get the error:
Warning: mssql_bind() [function.mssql-bind]: Unable to set parameter in
D:\Inetpub\wwwroot\folder\mypage.php on line 105
I discovered changing SQLVARCHAR to SQLTXT, and dropping the length of
8000 helps:
mssql_bind($stmt, '@mgrnotes',$mgrnotes,SQLTEXT,false,false);
I get no error, but the field is truncated to 8000 characters
regardless.
What is the correct way to use mssql_bind with strings of greater than
8000 characters?
Thanks!
Dave