this was true on php 4.01 but not on php 4.04pl1, i have to escape my
strings again. or it's some switch or conf setting i never
seen/heard/thought of...
i now use $var=addslashes($var) on php4.0.4pl1 redhat 7 where i do not have
to on a other system running php4.0.1 redhat 6.2 !
especially 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:15 PM
Subject: Re: apostrophe ....
> 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 where you
ran
> things through addslashes, it turns out like to look like randy\\\'s.
Which
> ends up being stored as randy\'s.
>
> To correct this, first fix your code, then run the following query:
>
> UPDATE table SET fieldname = REPLACE(fieldname,'\\','');
>
>
> ----- Original Message -----
> From: "Randy Johnson" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, March 13, 2001 9:54 AM
> Subject: apostrophe ....
>
>
> > 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
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
> >
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
