Jason Hawkins wrote:

Hi,
I am trying to INSERT into a MSAccess database using PHP 4.3 -
I have a problem when I enter a name like O'Donnell. In mysql I would
normally just backslash the single quote but this doesn't work with
MSAccess.
is there a fix for this??

Thanks in adv.

Jason

Most DBs allow you to use '' to quote a single quote. So:


INSERT INTO table (name) VALUES ('O''Donnel');

Or you could do the obvious and use:

INSERT INTO table (name) VALUES ("O'Donnel");

But that doesn't work with, say Oracle. (mysql handles both quotes just fine)

--
paperCrane <Justin Patrin>
--
Question Everything, Reject Nothing

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to