12 Replies Latest reply on Nov 21, 2016 6:19 AM by Mustafa KALAYCI

    Uncode left double quotation mark become question mark

    Mustafa KALAYCI

      Hello everyone,

       

      I have a problem about charsets. A customer of mine has a database with WE8ISO8859P9 charset (europe and turkish charset) and NLS_NCHAR_CHARACTERSET is AL16UTF16:

       

      SELECT PARAMETER, VALUE FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER LIKE '%CHARACTERSET';

      NLS_CHARACTERSET    WE8ISO8859P9

      NLS_NCHAR_CHARACTERSET    AL16UTF16

       

      Using company application, users copy some text from microsoft word and past into application and this data is inserted into a CLOB column. In this data there are double quotation marks but microsft curly double quotation mark, which is:    “  as I checked from word this is Unicode char with char code : 201C

      so this char is inserted as a question mark.

       

      create table tmp33 (f1 varchar2(100), f2 nvarchar2(100), f3 clob, f4 nclob);
      insert into tmp33 values ('“','“','“','“');    
      select * from tmp33;
      
      result is:
      ?    ?    ?    ?
      

       

      is this because of WE8ISO8859P9 or AL16UTF16 is not support this char or oracle client nls params is not support and I can not send this char to oracle ?

      db version is:

      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

      PL/SQL Release 11.2.0.3.0 - Production

      "CORE    11.2.0.3.0    Production"

      TNS for Linux: Version 11.2.0.3.0 - Production

      NLSRTL Version 11.2.0.3.0 - Production

       

      thanks

       

      Message was edited by: Mustafa KALAYCI

       

      Message was edited by: Mustafa KALAYCI, change the subject.