cut & paste into a TEXT column type

[cragm]

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

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

This error is actually half way down the text I am trying to enter.

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.

Thanks

[cragm]

just realised that I need addslashes

[Immerse]

mysql_real_escape_string() might be a bit better (assuming you're using MySQL).