Is learning to regular expressions, many still don't understand, such as: I am tamino 﨧 three-word utf8 encoding is 9 ec4, 5 b50 FA27,
So:
Select case when regexp_like (' I am tamino ', '[' | | unistr (' \ FA27') | | '] ') then the 'T' else 'F' end from dual;
Return to F, this should be no problem,
Select case when regexp_like (' I am tamino 﨧 ', '[' | | unistr (' \ FA27') | | '] ') then the 'T' else 'F' end from dual;
Return T, this should be no problem,
But:
Select case when regexp_like (' I am tamino ', '[' | | unistr (' \ FA26') | | '\ -' | | unistr (' \ FA28 ') | | '] ') then the 'T' else 'F' end from dual;
Also return T, is this why?