FreeTDS Development Group

[Mark Schaal <mark AT champ.tstonramp.com>]

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