sql server - Not inserting more than 300 characters using MSSQL query with PHP, using Zend_db_adapter -


when try insert string containing more 300 characters shows blank page , not return php error.

i using zf 1 - zend db adapter mssql server 2012.

$db = zend_db_table::getdefaultadapter(); $insert = "insert tbloffer (legal_restrictions) values ('more 300 character string')"; $stmt = $db->prepare($insert); $stmt->execute(); 

my database column datatype nvarchar(max)

in place of

$insert = "insert tbloffer (legal_restrictions) values ('more 300 character string')"; $stmt = $db->prepare($insert); $stmt->execute(); 

try one

$data = array('legal_restrictions'=> 'more 300 character string'); $db->insert('tbloffer',$data); 

Comments

Popular posts from this blog

matlab - "Contour not rendered for non-finite ZData" -

delphi - Indy UDP Read Contents of Adata -

javascript - Any ideas when Firefox is likely to implement lengthAdjust and textLength? -