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
Post a Comment