title: mysql type varchar versus text and blob
body: <p>I have a form that has a text area in it. The user types a comment and it gets inserted into my database. My problem arises when the comment has an apostrophe in it...When I go to retrieve the comment and display it on the screen the apostrophe doesn't show up, and seems to be transformed into some weird character. Do I need to choose a certain mysql data type (varchar, text, blob) to avoid this? </p>