DEFAULTESCCHAR configuration parameter

The DEFAULTESCCHAR configuration parameter specifies the default escape character that is used for LIKE and MATCHES conditions.

onconfig.std value
DEFAULTESCCHAR backslash character ( \ ).
if not present
The backslash character ( \ ) is used if no value is set in the onconfig file.
values
\ = The backslash character is used as the escape character.

NONE = No default escape character.

character = Any one-character value can be used as the escape character.

takes effect
After you edit your onconfig file and restart the database server.

Usage

The default value can be overridden in a session by using the SET ENVIRONMENT DEFAULTESCCHAR statement with the escape character that you want to use. For example:
SET ENVIRONMENT DEFAULTESCCHAR '\'

Copyright© 2019 HCL Technologies Limited