This discussion is archived
3 Replies Latest reply: Jan 25, 2013 3:49 AM by Christian Erlinger RSS

Oracle Fusion 11g & Character Set.

kingadmin Explorer
Currently Being Moderated
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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Hi kingadmin,
    Try This

    ALTER DATABASE CHARACTER SET AR8MSWIN1256
  • 3. Re: Oracle Fusion 11g & Character Set.
    Christian Erlinger Guru
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points