I have recently built a Content Management Sytem site that is migrating from an old site.
I can cut & paste OK when the form text field enters the data into the database where there is a VARCHAR column type but when trying to do the same into a TEXT column type I get this error message
This error is actually half way down the text I am trying to enter.Error updating staff member: You have an error in your SQL syntax near 'to The Cambridge Urban History of Britain , vol. 3 1840-1950 (2000). She is curr' at line 7
I know that TEXT has a maximum length of 65535 chars but this should easily be enough and if I manually type the text it works fine.
Can anyone tell me why this is happening please.