MySQL Forums :: Newbie :: MySQL Output Help

Advanced Search

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

Subject Written By Posted
MySQL Output Help Tommy Blax 12/29/2009 09:05AM
Re: MySQL Output Help Rick James 12/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.