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? Link to comment https://forums.phpfreaks.com/topic/262305-mediumtext-help/ 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. Link to comment https://forums.phpfreaks.com/topic/262305-mediumtext-help/#findComment-1344232 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.