Halid,
I think this is a php/phpmyadmin problem and not really a mysql problem.
PHP has an option called "magic quotes" that may be causing this.
http://us2.php.net/manual/en/function.get-magic-quotes-gpc.php
I have run into this before - I think what happens is that magic quotes
will change
Something is double escaping the strings.
Check if GPC magic string is enabled (apache's auto escaping).
Also check if your code manually escapes the strings.
Halid Faith wrote:
Hello
I use mysql 4.1.16 and php4.3.10 and phpmyadmin2.7 and apache-2.0.53 on
FreeBSD5.3
I add any text as data wit
I don't use ASP and VBScript with Macromedia Dreamweaver, but I think
the problem here is that you've misunderstood what is needed, rather
than that Dreamweaver's escaping mechanism doesn't work. Let me try to
explain. Mysql has no trouble with apostrophes in the data. The
problem comes when
Man I have been banging away at this for a week and I am only just
getting to a point where I am finding a resolution. There seems to be a
lot of info out there for this kind of thing, but very little on how to
implement it.
I use ASP and VBScript with Macromedia Dreamweaver so with asp I can
Try using QUOTE function.
Asif Iqbal wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi All
I have been using mysql database to collect my syslog data. It was
working fine. However recently I had few logs that had apotrophe and I
failed to insert those lines into my database. It said syntax e
At 22:30 -0500 1/7/04, Asif Iqbal wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Paul DuBois wrote:
At 21:35 -0500 1/7/04, Asif Iqbal wrote:
>-BEGIN PGP SIGNED MESSAGE-
>Hash: SHA1
>
>Paul DuBois wrote:
>> At 20:39 -0500 1/7/04, Asif Iqbal wrote:
>> >-BEGIN PGP SIGNED MESSA
msg.pgp
Description: PGP message
At 21:35 -0500 1/7/04, Asif Iqbal wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Paul DuBois wrote:
At 20:39 -0500 1/7/04, Asif Iqbal wrote:
>-BEGIN PGP SIGNED MESSAGE-
>Hash: SHA1
>
>Hi All
>
>I have been using mysql database to collect my syslog data. It was
>working fine. H
msg.pgp
Description: PGP message
At 20:39 -0500 1/7/04, Asif Iqbal wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi All
I have been using mysql database to collect my syslog data. It was
working fine. However recently I had few logs that had apotrophe and I
failed to insert those lines into my database. It said syntax erro
Message -
From: "Bryant Hester" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 07, 2003 6:48 AM
Subject: RE: apostrophe and comma error on submit
You need to delimit them:
INSERT INTO table VALUES ('value&#
You need to delimit them:
INSERT INTO table VALUES ('value','Don\'t know','');
If you're inserting via PHP, you need to add a backslash before
apostrophes or commas in the post data, as apostrophes and commas are
used by MySQL to delimit fields on INSERT statements.
It's also in the manual,
escape your data with a black slash
\' if you mean to have a literal single quotation mark.
-Original Message-
From: ahimsa [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 11:43 AM
To: [EMAIL PROTECTED]
Subject: apostrophe and comma error on submit
Does anyone know about an
On Wed, 24 Oct 2001, John Abel wrote:
> Hi,
>
> I am having bother trying to perform a select, that has an apostrophe in
> the value Im looking for. Below is the Perl code Im using.
>
> $SQLStatement = "SELECT ID FROM Albums WHERE Name =
> '".$DBHandle->quote($Name)."';";
> $STLook
t;René Tegel" <[EMAIL PROTECTED]>; "Eric Fitzgerald" <[EMAIL PROTECTED]>;
"Randy Johnson" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 12:40 AM
Subject: Re: apostrophe
>
> - Original Message -
> From: &qu
- Original Message -
From: "René Tegel" <[EMAIL PROTECTED]>
To: "Rolf Hopkins" <[EMAIL PROTECTED]>; "Eric Fitzgerald"
<[EMAIL PROTECTED]>; "Randy Johnson" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday,
<[EMAIL PROTECTED]>; "Eric Fitzgerald" <[EMAIL PROTECTED]>;
"Randy Johnson" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, March 14, 2001 1:27 AM
Subject: Re: apostrophe
> Or you can fix your php by turning off the magic_quotes_gpc flag. Yo
ssage -
From: "René Tegel" <[EMAIL PROTECTED]>
To: "Eric Fitzgerald" <[EMAIL PROTECTED]>; "Randy Johnson"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, March 14, 2001 2:56
Subject: Re: apostrophe
> this was true on php 4.
y php seems to have loads of undocumented - and worse, changing,
behaviour.
regards,
rene
- Original Message -
From: "Eric Fitzgerald" <[EMAIL PROTECTED]>
To: "Randy Johnson" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, March 13, 2001 7
Two things here.
First off, we had this problem spring up on us, and I think I may know why
it's doing it to you. If your using PHP, the more recent version
automatically escape out variables sent to the mysql driver. Thus randy's
is converted to randy's. HOWEVER, if you still have old code wh
Randy Johnson wrote:
>
> When a text with an apostrophe in it has a \' in it. How can I fix this?
>
> example
>
> randy's is stored in the DB as randy\'s
>
> thanks
>
> Randy
If you just want to fix that one instance just do
update set = 'randy\'s' where
-
21 matches
Mail list logo
