How can I search for a hex string in oracle?
SQL&gt; create table t1(c1 varchar2(20 char));

Table created.

SQL&gt; insert into t1 values ('Thcˇodore');

1 row created.

SQL&gt; commit;

Commit complete.

SQL&gt; select * from t1;

C1
--------------------------------------------------------------------------------
Thcˇodore

SQL&gt; select rawtohex(c1) from t1;

RAWTOHEX(C1)
--------------------------------------------------------------------------------
546863CB876F646F7265

SQL&gt; select c1 from t1 where rawtohex(c1) like '%CB87%';

C1
--------------------------------------------------------------------------------
Thcˇodore

SQL&gt;