[freetds] RE: Charset conversion with Sybase ASE 12.0

Lowden, James K LowdenJK at bernstein.com
Thu Jun 26 10:11:58 EDT 2003

> From: jose [mailto:jramos at cherrytel.com]
> Sent: June 26, 2003 6:08 AM
>     I´m using freetds-0.61with php-4.2.3 and sql server 7.0. 
>     My problem is when I try insert one registrer with a 
> string that contains the character ' or the character ", one 
> error ocurrs. If you see the insert sentence in the error 
> message you can look that this character is now protected 
> with \, and I haven´t put this protection.


Please see the archives of 6/23/2003 for a message from Arnar Birgisson.  He
explains PHP quoting.  

You should be able to insert a row by "doubling" the single quote, as

	mssql_query("insert mytable values ('It''s a boy')");

The information contained in this transmission may contain privileged and confidential information and is intended only for the use of the person(s) named above. If you are not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender immediately by reply e-mail and destroy all copies of the original message. Please note that we do not accept account orders and/or instructions by e-mail, and therefore will not be responsible for carrying out such orders and/or instructions.

More information about the FreeTDS mailing list