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 General 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]