2 Replies Latest reply on Oct 27, 2014 4:09 PM by rp0428

    apostrophe not acceptable in toad/oracle

    ef3081ea-38c5-4b99-b1c1-3c531f89f065


      Hi All,

       

      I am trying to validate a field using regexp like in which apostrophe has to be included. i don't get any compilation error in oracle forms, but that validation fails.

      When i queried

       

      select 

      'abinay’s' from

      dual;

       

      my output is abinay¿s

       

      The apostrophe which is chr(146) is not acceptable?

       

      Please share some thoughts quickly, as this is quite urgent.

       

      Thanks and Regards,

      Abinaya