Adding Strings with quote's in?

Mark Schaal mark at champ.tstonramp.com
Fri Feb 11 13:40:39 EST 2000



I belive you want to double up that single-quote.

INSERT INTO test VALUES( 'The Wolve''s are coming' );

Mark

> 
> Obviously, an
> 
> INSERT INTO test VALUES( 'The Wolve's are coming' );
> 
> Isn't going to cut it, so I used PHP's "AddSlashes" function, which does the
> equivalent of:
> 
> INSERT INTO test VALUES( 'The Wolve\'s are coming' );
> 
> Which it doesn't seem to like either...
> 
> Any suggestions? - Is there a problem doing this with FreeTDS? (We have
> another system running MySQL which I do manage to use AddSlashes to protect
> embedded quotes etc. in field data with)...
> 
> Thanks,
> 
> -Karl

-- 
Mark J. Schaal					Phone:      (909) 620-7724
TST On Ramp					Fax:	    (909) 620-8174
System Administrator				E-Mail: mark at tstonramp.com



More information about the FreeTDS mailing list