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 '\'