On Sat, Oct 14, 2000 at 04:15:11AM +0000, Thu Huynh wrote:
> Hello,
>
> Does anyone know how to insert/update data that contains single quote (')
> into a field? Data such as: John's house is in Dalas.
>
> I know one can insert double quote by using single quotes as field
> delimiters. But since I have to use single quotes as field delimiters, data
> cannot contain single quote. Is there a way to change the field delimiter?
Try escaping the single quote you want to put into the database.
'John\'s house is in Dalas'
--
-- C^2
No windows were crashed in the making of this email.
Looking for fine software and/or web pages?
http://w3.trib.com/~ccurley