mssql_bind question

From: 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

« previous php.general (#317494) next »