#19061 [NEW]: Insert Statment Fail bcoz of Lenght too long

From: c_aluthge@hotmai.com Operating system: HP UX 11.00 PHP version: 4.1.2 PHP Bug Type: *General Issues Bug description: Insert Statment Fail bcoz of Lenght too long I'm trying to insert a record to one of my talble. The column "comments" is a Char (1250) , but i cant insert any values thru my PHP Program with a lenth more than 256 Char. this is the SQL Statment $insert_record = "insert into msm_account". "(account_num,comments,activity_type,due_activity_type,record_stat,due_date,entry_date,update_date,update_user)". "values '$account_num','$comments','$activity_type','$due_activity_type',"."'$record_stat','$due_date','today','today','$user_name')"; Output of the statment .... Lenght : 259 Insert : insert into <TABLE NAME> account_num,comments,activity_type,due_activity_type,record_stat,due_date,entry_date,update_date,update_user)values ('510000075','aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa','NONE','NONE','N','23/08/2002','today','today','xxxx') Warning: Prepare fails (E [SQLSTATE=IX 000 SQLCODE=-280]) in /www/htdocs/MSm/docs/xxx_rec.php on line 57 Failed to Insert record -- Edit bug report at http://bugs.php.net/?id=19061&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=19061&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=19061&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=19061&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=19061&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=19061&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=19061&r=support Expected behavior: http://bugs.php.net/fix.php?id=19061&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=19061&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=19061&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=19061&r=globals