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?
CodePudding user response:
Added that at the time of insertion, actual data insert sformula actual length is 424