Re: INSERT into MSSQL Server
| From: | Frank M. Kromann | Date: | Wed, 14 Feb 2001 00:43:19 +0000 |
| Subject: | Re: INSERT into MSSQL Server | ||
| Groups: | php.general php.windows | ||
| Request: | Send a blank email to php-general+get-39547@lists.php.net to get a copy of this message | ||
It is only the ' charactor there has a "problem" you have to excape any special
character before inserting.
the text Joe's should be inserted like this"
INSERT INTO table1 (int_field, char_field) VALUES (1, 'Joe''s')
A single quote is escaped by an extra single quote.
- Frank
>I trying to insert some data into a MSSQL Server 7.0 database from Php. Some
>of the data has various characters ', > . How can I tell SQL Server to
>treat these characters as part of the input.
>
>Ryan Conover
>
>--
>PHP Windows Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net
>For additional commands, e-mail: php-windows-help@lists.php.net
>To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>
>