Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Unexpected result for like with COLLATE and ESCAPE

Mario BehringerFeb 22 2024

Hi,

I discovered the following behavior:

CREATE TABLE "TABLE_1" ("TEST" VARCHAR2(255));
INSERT INTO TABLE_1 values ('TEST TEST/TEST_TEST_TEST');
SELECT * from TABLE_1 where test COLLATE BINARY_CI like '%t\_t%' ESCAPE '\';

Which gives back the expected result (one row) on Oracle 12.2.0.1.0 but will give back no result on Oracle 19.0.0.3.

The question would be whether I hit a (known) bug or I simply need to adjust a setting?

Maybe someone can give me a hint.

This post has been answered by Paulzip on Feb 22 2024
Jump to Answer
Comments
Post Details
Added on Feb 22 2024
11 comments
172 views