Subject | Re: String delimiter |
---|---|
Author | Aage Johansen |
Post date | 2003-08-01T18:03:11Z |
On Fri, 1 Aug 2003 05:18:03 +0000 (UTC), Helen Borrie wrote:
--
Aage J.
> At 04:59 AM 1/08/2003 +0000, you wrote:This looks like a parser problem in _very_ old IBX versions.
>> Firebird Quick Start Guide 1.1 states ...
>>
>> If you need to use an apostrophe inside a Firebird string, you
>> can "escape" the apostrophe character by
>> preceding it with another apostrophe.
>>
>>
>> .... Accepted.
>>
>> What about using ; in strings -->
>>
>> gives an error -> -104 Unexpected end of statement
>>
>> 'stri;ng' gives error.
>
> Not on my system it doesn't.
>
> SQL> SELECT 'abc;def' AS OUTPUT FROM RDB$DATABASE;
> ...
--
Aage J.