I have a form application and I’ve added a multi-line text field to it, but for some reason I cannot get any edits/text entries in the field to save to the database, nor when I add data to the field in the database itself, the application will not display it. All of the other fields/field types read and write perfectly. Any suggestions as to what I’m missing? I have tried setting the field type (MySQL) as LONGTEXT and VARCHAR but no difference. Do I need it to be a specific datatype, like BLOB()?
Actually it should simply work. Issues that can occur if you have a quote in your text then you need to escape the string before update. Sometimes it helps if you set debug mode sql to on. then you can see what is generated and usually it is very informative if you search for problems.