INSTR2(x, UNISTR('\D834')) : Unicode « PL SQL Data Types « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. PL SQL Data Types
  3. Unicode
SQL>
SQL> DECLARE
  2    x NCHAR(40) := UNISTR('This is a \D834\DD1E test');
  3  BEGIN
  4    DBMS_OUTPUT.PUT_LINE (INSTR2(x, UNISTR('\D834')));
  5    DBMS_OUTPUT.PUT_LINE (INSTR4(x, UNISTR('\D834')));
  6  END;
  7  /

PL/SQL procedure successfully completed.

SQL>
SQL>








21.47.Unicode
21.47.1.The underlying database datatype for this example is Unicode UTF-8
21.47.2.Find the location of '\0303' using INSTRC
21.47.3.INSTR2(x, UNISTR('\D834'))