MySQL Forums
Forum List  »  Newbie

MySQL Output Help
Posted by: Tommy Blax
Date: December 29, 2009 09:05AM

I'm very new to MySQL so forgive me if I haven't explained myself properly or if this is the wrong place to post.

Okay well, i'm making a small project which involves somebody answering a few questions in textareas, and the answers are stored in MySQL. The Text output appears fine, but when I either put in a ' or a " it adds 3 backslashses before it. So for example:

My Input = Hello, I'm A Turtle
The Output = Hello, I\\\'m A Turtle

It's quite irritating when you end up putting a lot of 's and "s in :P. Is there any way I can fix this?

(( it also appears as \\\' in the MySQL row on phpMyAdmin, and the row for the answer is Text Type, Collaboration is latin1_general_ci and there is no null ))

I'd really appreciate some help, thank you.

Options: ReplyQuote

Written By
MySQL Output Help
December 29, 2009 09:05AM
December 30, 2009 12:37PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.