how to change delimiter single-quote ?

On Tue, 29 Jun 1999, abdelkrim wrote:

Hello

I'have some problems with single-quote,
if i insert some text with single-quote ( ' ) error occured !!!
thanks

The common way to achieve this is to double up the quotes:

INSERT INTO table (column) VALUES ('Some ''quoted'' text');

Simon.

--
"Half-dead cat found in box -- Animal Rights group seeks Austrian scientist"

Simon Drabble Somewhere in cyberspace
simond@foxlink.net

On Tue, 29 Jun 1999, abdelkrim wrote:

Hello

I'have some problems with single-quote,
if i insert some text with single-quote ( ' ) error occured !!!
thanks

The common way to achieve this is to double up the quotes:

INSERT INTO table (column) VALUES ('Some ''quoted'' text');

Simon.

--
"Half-dead cat found in box -- Animal Rights group seeks Austrian

scientist"

Simon Drabble Somewhere in cyberspace
simond@foxlink.net

is't no way to change the single-quote to an another character ?

You can backquote the quote:
'Don\'t do that'

abdelkrim wrote:

Hello

I'have some problems with single-quote,
if i insert some text with single-quote ( ' ) error occured !!!
thanks

The common way to achieve this is to double up the quotes:
INSERT INTO table (column) VALUES ('Some ''quoted'' text');

I don't try it, but in such a cases I use something like that:
'Some \'quoted\' text'
Rem

-------------------------------------------------------------------*------------
Remigiusz Sokolowski e-mail: rems@gdansk.sprint.pl * *
-----------------------------------------------------------------*****----------