3 Replies Latest reply: Jan 25, 2013 5:49 AM by Christian Erlinger RSS

    Oracle Fusion 11g & Character Set.

    kingadmin
      Hi,

      OS : Windows 7 .64bit.
      jdk : jdk-7u11-windows-x64
      weblogic : wls1036_generic

      How i can change the form character set like (ARABIC_UNITED ARAB EMIRATES.AR8MSWIN1256).

      Regards,
        • 1. Re: Oracle Fusion 11g & Character Set.
          Fabrizio Delli Priscoli
          From the online documentation (here is the link: http://docs.oracle.com/cd/E24269_01/doc.11120/e24477/basics.htm):


          3.2.4 Standard Fonts and Icons File

          Registry.dat is the file that contains the default font, font mappings, and icon information that Forms Services uses.

          Location: $DOMAIN_HOME/config/fmwconfig/servers/WLS_FORMS/applications/formsapp_11.1.2/config/forms/registry/oracle/forms/registry

          For a sample of the default Registry.dat, see Appendix C, "Registry.dat."

          For more information about Registry.dat, see Chapter 4, "Deploying Fonts, Icons, and Images Used by Forms Services."



          If you want to change nls parameter, here is an example in section "3.3.1 Deploying Your Application":

          To modify an environment file, select the file in the Environment Configuration page of Fusion Middleware Control and add or edit environment variables as needed by your application. For example, you can add the environment variable shown in Table 3-2.

          Table 3-2 Example of Environment Variable Values

          Environment Variable Name     Environment Variable Value
          NLS_LANG NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1

          If you specified these environment variables in an environment file, specify this environment file in the respective configuration section of the formsweb.cfg in the Web Configuration page.


          Hope it helps you,
          Fabrizio
          • 2. Re: Oracle Fusion 11g & Character Set.
            942420
            Hi kingadmin,
            Try This

            ALTER DATABASE CHARACTER SET AR8MSWIN1256
            • 3. Re: Oracle Fusion 11g & Character Set.
              Christian Erlinger
              Try This

              ALTER DATABASE CHARACTER SET AR8MSWIN1256
              Besides this will change the database characterset instead the forms characterset (and in 90% of times either fail or corrupt the database) the recommended method of changing the database characterset is cmig/csalter: http://docs.oracle.com/cd/B19306_01/server.102/b14225/ch11charsetmig.htm
              And even csmig won't work if the target characterset is not a superset of the source characterset (you can't go from WE8MSWIN1252 to AL32UTF8 for example)

              cheers