Re: how to store quotes in mysql?

2006-08-10 Thread Renato Golin
thanks for your response. I'm already working on the php part but just wondered how bad is to have backslash in front of quotes. It's bad in the sense that you will have to predict every single event (character) from the input and act accordingly. The API writers had predicted them all and

how to store quotes in mysql?

2006-08-09 Thread afan
hi to all. battling this problem on several forums and mailing lists, I got confused: when store string that contains quotations (ie afan's php shop) in mysql does it have to be stored with backslashes (afan\'s \php\ shop) or just the way it is? my login's telling me the way it is. am I wrong?

Re: how to store quotes in mysql?

2006-08-09 Thread Chris White
On Wednesday 09 August 2006 07:49 am, [EMAIL PROTECTED] wrote: hi to all. battling this problem on several forums and mailing lists, I got confused: when store string that contains quotations (ie afan's php shop) in mysql does it have to be stored with backslashes (afan\'s \php\ shop) or just

RE: how to store quotes in mysql?

2006-08-09 Thread Kristen G. Thorson
battling this problem on several forums and mailing lists, I got confused: when store string that contains quotations (ie afan's php shop) in mysql does it have to be stored with backslashes (afan\'s \php\ shop) or just the way it is? my login's telling me the way it is. am I wrong?

Re: how to store quotes in mysql?

2006-08-09 Thread Chris White
On Wednesday 09 August 2006 08:37 am, Kristen G. Thorson wrote: [ stuff here ] kgt I'm confused.. did you read my email? Most of what you said doesn't seem to correlate with what I said. Can you quote the specific lines that you're disagreeing with? -- Chris White PHP Programmer/DBacillus

RE: how to store quotes in mysql?

2006-08-09 Thread Kristen G. Thorson
-Original Message- From: Chris White [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 09, 2006 11:43 AM To: mysql@lists.mysql.com Subject: Re: how to store quotes in mysql? On Wednesday 09 August 2006 08:37 am, Kristen G. Thorson wrote: [ stuff here ] kgt I'm confused

Re: how to store quotes in mysql?

2006-08-09 Thread Renato Golin
[EMAIL PROTECTED] wrote: hi to all. battling this problem on several forums and mailing lists, I got confused: when store string that contains quotations (ie afan's php shop) in mysql does it have to be stored with backslashes (afan\'s \php\ shop) or just the way it is? my login's telling me

Re: how to store quotes in mysql?

2006-08-09 Thread afan
thanks for your response. I'm already working on the php part but just wondered how bad is to have backslash in front of quotes. thanks. -afan [EMAIL PROTECTED] wrote: hi to all. battling this problem on several forums and mailing lists, I got confused: when store string that contains