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

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

From
"abdelkrim"
Date:

>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 ?