> I'm not sure what kind of escaping is being talked about.
Yes we are talking about the ESCAPE char in the LIKE clause.
Especially about if there is an <default> ESCAPE character when the
ESCAPE keyword is NOT! provided
And yes: Standard is that this ESCAPE keyword can be used!
But it seems its not standard,
1. that there is a default ESCAPE char active, if the keyword ESCAPE
is NOT used
2. that ESCAPE '' i.e. with empty string (meaning "no escape char
active") can be provided ..
and this what I meant with proprietary feature
SQL Server also does have no default ESCAPE char. At least at
following site
http://msdn.microsoft.com/en-us/library/aa933232(SQL.80).aspx
it is mentioned:
"To search for the percent sign as a character instead of as a
wildcard character, the ESCAPE keyword and escape character must be
provided"
Nothing about a default. And I have verified this just now (at least
that it does not have the '\' as default)
Regards
Charly
On 13 Aug., 08:33, Thomas Kellerer <[email protected]>
wrote:
> On 9 Aug., 16:53, charly <[email protected]> wrote:
>
> > This would be a proprietary feature of H2 (and maybe other databases
> > like the above mentioned Oracle)
> > and is fine, if the SQL-statements are running only on H2 i.e. need
> > not be portable.
>
> I'm not sure what kind of escaping is being talked about.
>
> If this is the character that is supposed to turn a SQL wildcard in a
> regular character (so that you can e.g. search for % sign) then there
> _is_ a standard for this:
>
> SELECT *
> FROM my_table
> WHERE some_column LIKE '\%' escape '\';
>
> This is defined in the SQL standard and to supported at least
> Postgres, Oracle, SQL Server and DB2.
>
> Regards
> Thomas
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
