I have a problem with update in MySql database.
In a university system a student apply for what is called a petition then the admin signs it and adds a note.
When the admin signs for the first time and enters his note it works.
But when the student Apply another time for the same petition and when the admin tries to enter his not and sign.
The note is not inserted to the table.
Notice that the query updates the record in the database and that the two times he insert have different ids.
The weird thing is that the query updates all other fields correctly.
Only the admin note is not updated.
Thing I tried:
I printed it out it worked.
I changed the structure from varchar to text .
I changed the Collation from latin1_swedish_ci to utf8_unicode_ci.