11 Replies Latest reply: Jan 22, 2013 10:49 PM by Nitesh. RSS

    Ascii value of small leter “e” with grave character (Rivière)

    960008
      Hi all,
      I want to get ASCII Value of the character for a small leter “e” with grave character (Rivière):

      I ran following:

      SQL> select ascii(è) from dual;
      select ascii(è) from dual
      *
      ERROR at line 1:
      ORA-00911: invalid character


      SQL> select ascii('è') from dual;
      ERROR:
      ORA-01756: quoted string not properly terminated


      SQL> select ascii("è") from dual;
      ERROR:
      ORA-01740: missing double quote in identifier

      Some how I'm not getting it.
      Any idea, what wrong I'm doing.

      Amit