On Mon, Apr 9, 2012 at 1:42 PM, David Stoltz wrote:
> 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
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
this is a limit in SQL itself not the drivers
http://msdn.microsoft.com/en-us/library/aa258848(v=SQL.80).aspx
Using EXECUTE with a Character String
Use the string concatenation operator (+) to create large strings for
dynamic execution. Each string expression can be a mixture of Unicode and
non-Unicode data types.
Although each [N] '*tsql_string*' or *@string_variable* must be less than
8,000 bytes, the concatenation is performed logically in the SQL Server
parser and never materializes in memory. For example, this statement never
produces the expected 16,000 concatenated character string:
EXEC('name_of_8000_char_string' + 'another_name_of_8000_char_string')
Statement(s) inside the EXECUTE statement are not compiled until the
EXECUTE statement is executed.
Changes in database context last only until the end of the EXECUTE
statement. For example, after the EXEC in this example, the database
context is *master*:
USE master EXEC ("USE pubs") SELECT * FROM authors
