CHAPTER 10 Database Error Messages
809
Invalid escape character ’%1’
Item Value
SQLCODE -629
Constant SQLE_INVALID_ESCAPE_CHAR
SQLSTATE 22019
Sybase error code 7707
ODBC 2 State S1000
ODBC 3 State 22019
The escape character string length must be exactly one.
Invalid escape sequence ’%1’
Item Value
SQLCODE -630
Constant SQLE_INVALID_ESCAPE_SEQ
SQLSTATE 22025
Sybase error code 7705
ODBC 2 State S1000
ODBC 3 State 22025
Parameter 1 The escaped character
A LIKE pattern contains an invalid use of the escape character. The escape
character may only precede the special characters ’%’, ’_’, ’[’, and the escape
character itself.
Probable cause
Probable cause