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.