4 Replies Latest reply: Jul 4, 2012 12:12 AM by sb92075 RSS

    National Character setting

    user10569054
      DB version

      Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit

      using Sql/Developer version 1.5 to test

      My DB has National character set set to unicode (NLS_NCHAR_CHARACTERSET     AL16UTF16) and character set to US7ASCII (NLS_CHARACTERSET     US7ASCII).

      When i create a table with nvarchar2 column and insert in a my language word (month name) then upon fetching rows it shows some different results... why such behavior?
      select sysdate from dual;
      
      04-जुलै      -12
      
      create table test_nj (a nvarchar2(50));
      
      insert into test_nj values('जुलै');
      
      commit;
      
      select * from test_nj;
      
      A2H
      A2H
      A2H
      A2H
        • 1. Re: National Character setting
          sb92075
          user10569054 wrote:
          DB version

          Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit

          using Sql/Developer version 1.5 to test

          My DB has National character set set to unicode (NLS_NCHAR_CHARACTERSET     AL16UTF16) and character set to US7ASCII (NLS_CHARACTERSET     US7ASCII).

          When i create a table with nvarchar2 column and insert in a my language word (month name) then upon fetching rows it shows some different results... why such behavior?
          select sysdate from dual;
          
          04-जुलै      -12
          
          create table test_nj (a nvarchar2(50));
          
          insert into test_nj values('जुलै');
          
          commit;
          
          select * from test_nj;
          
          A2H
          A2H
          A2H
          A2H
          do you have data storage problem or data presentation problem?

          SELECT ASCII_STR(A) FROM TEST_NJ;

          post results from above.
          • 2. Re: National Character setting
            user10569054
            do you have data storage problem or data presentation problem?
            No. This is a normal running Test DB with monthly cold backup refreshment with same H/W,S/W,storage option,structure as that of Production DB.
            SELECT ASCII_STR(A) FROM TEST_NJ;
            it gives error ORA-00904: "ASCII_STR": invalid identifier.
            • 3. Re: National Character setting
              sb92075
              user10569054 wrote:
              do you have data storage problem or data presentation problem?
              No. This is a normal running Test DB with monthly cold backup refreshment with same H/W,S/W,storage option,structure as that of Production DB.
              SELECT ASCII_STR(A) FROM TEST_NJ;
              it gives error ORA-00904: "ASCII_STR": invalid identifier.
              oops.

              SELECT ASCIISTR(A) FROM TEST_NJ;
              • 4. Re: National Character setting
                user10569054
                same result
                SELECT ASCIISTR(A) FROM TEST_NJ;
                
                A2H
                A2H
                A2H
                A2H
                Regards!