2 Replies Latest reply: Jan 9, 2012 9:48 AM by francy77 RSS

    strange character in sqlplus

    francy77
      hi all, i've find a very strange problem:

      if i run this query in plsql developer:


      select ascii(substr(ds_esito_mef,1,1)),substr(ds_esito_mef,1,1) from ESITI_MEF_IAER0_RD where key_id_ds_nota=1885212127


      i get:

      ASCII(SUBSTR(DS_ESITO_MEF,1,1)     SUBSTR(DS_ESITO_MEF,1,1)
      14844060      “


      if i run the same query with sqlplus i get:

      SQL> select ascii(substr(ds_esito_mef,1,1)),substr(ds_esito_mef,1,1) from ESITI_MEF_IAER0_RD where key_id_ds_nota=1885212127;

      ASCII(SUBSTR(DS_ESITO_MEF,1,1)) SUBS
      ------------------------------- ----
      14844060 ô


      in other word, the first give me the symbol “  while the second give me ô  even if the ascii code is the same, why this happens?

      francesco
      thanks