2 Replies Latest reply: Sep 25, 2012 3:09 AM by 877599 RSS

    xml parsing query character shuffled

    877599
      Hi,

      when we are parsing xml query into our Test Database we are getting result and all Text character are fine . but when we are parsing same query into our production database we are getting result but the all text character shuffled. we checked the character set in both database
      Test Database Character set: AL16UTF16 NCHAR NCHAR character set AR8MSWIN1256 character set
      Production Database Character set :AR8ISO8859P6 character set and AL16UTF16 NCHAR character set
      please help me solve this issue
      Production Database Details;
      Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
      PL/SQL Release 10.2.0.4.0 - Production
      CORE 10.2.0.4.0 Production
      TNS for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Productio
      NLSRTL Version 10.2.0.4.0 – Production

      Test Database Details:
      Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
      PL/SQL Release 10.2.0.3.0 - Production
      CORE 10.2.0.3.0 Production
      TNS for Linux: Version 10.2.0.3.0 - Production
      NLSRTL Version 10.2.0.3.0 - Production

      Thanks,
      John