#1  
Old 24th August 2021, 07:33 PM
mastinf mastinf is offline
Junior Member
 
Join Date: Sep 2008
Posts: 6
Question Does exists a default escape per special characters ?

I'm wondering if exists a default escape character for sql special characters or have to use the ESCAPE statement. thanks.
  #2  
Old 25th August 2021, 08:42 AM
Eivind Bakkestuen
 
Posts: n/a
Default Re: Does exists a default escape per special characters ?

> I'm wondering if exists a default escape character for sql special
> characters or have to use the ESCAPE statement. thanks.


Escape chars are as documented in the help file. Anything special you
are wondering about?

--

Eivind [NX]
  #3  
Old 30th August 2021, 10:02 PM
Roberto Nicchi
 
Posts: n/a
Default Re: Does exists a default escape per special characters ?

Il 24/08/2021 23:42, Eivind Bakkestuen ha scritto:
>> I'm wondering if exists a default escape character for sql special
>> characters or have to use the ESCAPE statement. thanks.

>
> Escape chars are as documented in the help file. Anything special you
> are wondering about?
>


I see i can set an escape character using rhe ESCAPE statement. I was
wondering if there's a predefined escape character that is available
without the needs to use the ESCAPE statement. In the manual can't find it.
Anyway it's not important anymore. I have used the ESCAPE statement.

thanks

Roberto

  #4  
Old 30th August 2021, 10:37 PM
Thorsten Engler [NDA]
 
Posts: n/a
Default Re: Does exists a default escape per special characters ?

Roberto Nicchi wrote:

> I see i can set an escape character using rhe ESCAPE statement. I was
> wondering if there's a predefined escape character that is available without
> the needs to use the ESCAPE statement. In the manual can't find it. Anyway
> it's not important anymore. I have used the ESCAPE statement.


According to ISO 9075-2:2016 The default value for the escape character in
absence of an ESCAPE clause is NULL.

  #5  
Old 31st August 2021, 02:01 AM
Roberto Nicchi
 
Posts: n/a
Default Re: Does exists a default escape per special characters ?

Il 30/08/2021 13:37, Thorsten Engler [NDA] ha scritto:
> Roberto Nicchi wrote:
>
>> I see i can set an escape character using rhe ESCAPE statement. I was
>> wondering if there's a predefined escape character that is available without
>> the needs to use the ESCAPE statement. In the manual can't find it. Anyway
>> it's not important anymore. I have used the ESCAPE statement.

>
> According to ISO 9075-2:2016 The default value for the escape character in
> absence of an ESCAPE clause is NULL.
>


thank you

Roberto


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
CHR and extended characters David Rose nexusdb.public.support.sql 6 1st March 2018 04:29 AM
escape character to disable wildcard in LIKE Scott H nexusdb.public.discussions 1 1st October 2009 06:14 PM
SQL and accented characters Bert Binnenmarsch nexusdb.public.support.sql 5 12th December 2006 05:04 PM
!! help needed with regard to special characters !! Hans-Peter Grahsl nexusdb.public.support.adoprovider 5 17th June 2005 04:53 PM
Finding strange characters. David Guest nexusdb.public.support.sql 7 14th January 2004 11:36 AM


All times are GMT +11. The time now is 08:23 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.