Use the text field in the table, but update, if more than 256 bytes will be an error, an error is as follows:
The Bind parameter value for 8 ':' is too big (850)
No changes made to the database.
INSERT INTO paitem (sitemid, sitemname sserialnum, scyid, sdeleted, sfield, sispayrolldata, sformula) VALUES (?,?,?,?,? ,? ,? ,? ,? ,? ,? ,? )
Sformula column is the text type,
Do you have encountered such a problem? The text field should be how to use? More than 256 of the length of the string how to save?
Added that at the time of insertion, actual data insert sformula actual length is 424
CodePudding user response:
Your field type, estimation is TINYTEXT, try to the textCodePudding user response:
Is a text field, there is no problem, but also tried to varchar (1000), is also not line,