I was testing out my program and my button works fine, so I know my script, and SQL code is ok, but I noticed that I kept getting an error if the note I was adding was too long. It looked like this.
VALUES (?, ?, ?, ?)": Data truncation: Data too long for column ‘Notes’ at row 1
caused by MysqlDataTruncation: Data truncation: Data too long for column ‘Notes’ at row 1
Is this a setting within the MY SQL DB that I need to change so that there is not a character cap on a note that can be added to the database? And I’m not talking about typing a paragraph or anything, but I typed the following and it was too long: “How long is too long for a note to be added??” Just wondering if it’s a setting within MY SQL or within Ignition that i need to change?