Обсуждение: how to change delimiter single-quote ?

Поиск
Список
Период
Сортировка

how to change delimiter single-quote ?

От
"abdelkrim"
Дата:
Hello

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


Re: [GENERAL] how to change delimiter single-quote ?

От
Simon Drabble
Дата:
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


Re: [GENERAL] how to change delimiter single-quote ?

От
Chris Bitmead
Дата:
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

Re: [GENERAL] how to change delimiter single-quote ?

От
Remigiusz Sokolowski
Дата:
>
> > 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           * *
-----------------------------------------------------------------*****----------