Re: USING PHP to add ' to SQL
| From: | Stas Trefilov | Date: | Thu, 27 Jul 2000 08:48:11 +0000 |
| Subject: | Re: USING PHP to add ' to SQL | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-1340@lists.php.net to get a copy of this message | ||
"Tom.com" wrote:
> Anybody know how to handle those characters such as " ' ", " | " etc
> when
> insert into a SQL database?
To add ' to a field type it twice in a string, like that:
set INFO = 'This is Mike''s comment'
P.S. At least this works for Oracle...
--
Stas Trefilov
Moscow Russia