I'm having a problem posting a form which has a textarea to a MySQL database.

The database field is a LONGTEXT field but when someone inputs an apostrophe ' the text does not get inputted into the database.

TIA.

Replace the ' with '' (single quote with double single quotes) that should solve the problem.

BTW, no mention about what frontend you are using. this is posted on ASP forum, I assume that you are using ASP as frontend. So you can make use of REPLACE() function to do that, before inserting into DB.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

happygv,

I'm sorry that I didn't mention it in my post, but yes the frontend is ASP.

I was able to use the REPLACE function before entering it into my DB and it worked perfectly.

Thanks.