4 Replies Latest reply: Apr 10, 2012 7:02 PM by Srini Chavali-Oracle RSS

    ÂâÊêÎîÔôÛÜüÇ these characters are loading as 0000000162900000000000000

    user352937
      hi guys


      db version is 11.2.0.2

      linux x86_64


      PROPERTY_NAME PROPERTY_VALUE
      ------------------------------ --------------------------------------------------
      NLS_NUMERIC_CHARACTERS .,
      NLS_CHARACTERSET AL32UTF8
      NLS_NCHAR_CONV_EXCP FALSE
      NLS_NCHAR_CHARACTERSET AL16UTF16



      when we try to load into AL32UTF8 database it loads as junk characters, can anyone tell why?


      thanks
        • 1. Re: ÂâÊêÎîÔôÛÜüÇ these characters are loading as 0000000162900000000000000
          sb92075
          902988 wrote:
          hi guys


          db version is 11.2.0.2

          linux x86_64


          PROPERTY_NAME PROPERTY_VALUE
          ------------------------------ --------------------------------------------------
          NLS_NUMERIC_CHARACTERS .,
          NLS_CHARACTERSET AL32UTF8
          NLS_NCHAR_CONV_EXCP FALSE
          NLS_NCHAR_CHARACTERSET AL16UTF16



          when we try to load into AL32UTF8 database it loads as junk characters, can anyone tell why?
          something is wrong.

          do you have a data storage problem or a data presentation problem.

          SELECT ASCIISTR(FOREIGN_COL) FROM FOREIGN_TBL WHERE ID = 1;

          change SQL above to match your situation & post SQL & results back here (COPY & PASTE)
          • 2. Re: ÂâÊêÎîÔôÛÜüÇ these characters are loading as 0000000162900000000000000
            user352937
            SQL> SELECT ASCIISTR(desc) from test;

            ASCIISTR(RECORD_CONTENT_DESC)
            ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
            \FFFD\FFFD\FFFD\FFFD\FFFD\FFFD\FFFD\FFFD\FFFD\FFFD\FFFD\FFFD\FFFD\FFFD\FFFD\FFFD\FFFD

            SQL>

            i want data as it is ÂâÊêÎîÔôÛÜüÇ like this
            • 3. Re: ÂâÊêÎîÔôÛÜüÇ these characters are loading as 0000000162900000000000000
              sb92075
              902988 wrote:
              SQL> SELECT ASCIISTR(desc) from test;

              ASCIISTR(RECORD_CONTENT_DESC)
              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
              \FFFD\FFFD\FFFD\FFFD\FFFD\FFFD\FFFD\FFFD\FFFD\FFFD\FFFD\FFFD\FFFD\FFFD\FFFD\FFFD\FFFD

              SQL>

              i want data as it is ÂâÊêÎîÔôÛÜüÇ like this
              First you need to get those characters into the DB.
              • 4. Re: ÂâÊêÎîÔôÛÜüÇ these characters are loading as 0000000162900000000000000
                Srini Chavali-Oracle
                902988 wrote:
                hi guys


                db version is 11.2.0.2

                linux x86_64


                PROPERTY_NAME PROPERTY_VALUE
                ------------------------------ --------------------------------------------------
                NLS_NUMERIC_CHARACTERS .,
                NLS_CHARACTERSET AL32UTF8
                NLS_NCHAR_CONV_EXCP FALSE
                NLS_NCHAR_CHARACTERSET AL16UTF16



                when we try to load into AL32UTF8 database it loads as junk characters, can anyone tell why?


                thanks
                Pl post details of exact OS version, along with details of how exactly you loaded the data into the database.

                HTH
                Srini