HCProfessionals Posted May 9, 2012 Share Posted May 9, 2012 I am building a program to allow users to include a bio for themselves. The problem is, if they enter a special character into the textarea, MySQL throws errors. How can I fix this? Quote Link to comment Share on other sites More sharing options...
premiso Posted May 9, 2012 Share Posted May 9, 2012 The questions is a bit vague, especially without any code. The main thing to check is that A: your site and your MySQL server are using the same charsets, and if you are doing special characters, you should use UTF8 for both. B: Make sure you are escaping the data going into mysql properly, either with prepared statements or mysql_real_escape_string Aside from that, I am not sure where else to go without seeing the code to potentially help you out there or even the "errors" that are being thrown. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.