Re: PHP/MySQL + 'special' characters

From: 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

« previous php.db (#2634) next »