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: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
