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