Re: PHP/MySQL + 'special' characters
| From: | joe at jWebMedia dot com | Date: | Tue, 05 Sep 2000 22:10:02 +0000 |
| Subject: | Re: PHP/MySQL + 'special' characters | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-2634@lists.php.net to get a copy of this message | ||
That may work, however, one big concern right now is getting some tab delimited
text into the DB as well, so how MySQL will handle it is a problem. The server has
magic_quotes on, so that should hopefully help with data from the web. Will that
take care of the accent issue, or do I need to locally turn off magic_quotes and
do addslashes()? thanks,
Joe
Gavster wrote:
> Yo Joe,
>
> Did you try the addslashes() function?
>
> At 04:56 PM 09/05/00 -0500, you wrote:
> >Actually, I can't use this because I need to have the user input the data so I
> >can't count on them to do this. Anyway, I did try to do this once and it still
> >freaked...any other ideas? Thanks
> >
> >John Guynn wrote:
> >
> > > Have you tried escaping the character when you enter it? In other
> > words put
> > > a \ before the character MySQL balks at. That simple fix has saved me many
> > > headaches recently.
> > >
> > > John Guynn
> >
> >
> >--
> >PHP Database Mailing List (http://www.php.net/)
> >To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> >For additional commands, e-mail: php-db-help@lists.php.net
> >To contact the list administrators, e-mail: php-list-admin@lists.php.net