Re: How do you insert a ' character into the database?

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Wed, 27 Sep 2000 14:55:26 +0200
Message-ID: <8qsqqf$a1e$1@s1.read.news.oleane.net>

Double it:
insert into t (col) values ('it''s a ''');

--
Have a nice day
Michel


Shaun Campbell <shaun.campbell_at_entranet.co.uk> a écrit dans le message :
8qsnvu$kpi$1_at_soap.pipex.net...


> Can anyone tell me whether it is possible to enter a ' single quote

> character into a database column?

>

> Regards

>

> Shaun Campbell

>

>

Received on Wed Sep 27 2000 - 07:55:26 CDT

This message: [ Message body ]
Next message: trevor burkin: "Re: How do you insert a ' character into the database?"
Previous message: Shaun Campbell: "How do you insert a ' character into the database?"
In reply to: Shaun Campbell: "How do you insert a ' character into the database?"
Next in thread: trevor burkin: "Re: How do you insert a ' character into the database?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US