Populating the Localized Strings for Each Double-Byte Language (Oracle)

Like Sybase databases, Oracle requires only one database for each of the HQ and Schema database, as each database should have all language strings in it.

To populate the localized strings for each double-byte language:

  1. Follow the steps in the topic Creating the Oracle Database, so that the Oracle database with all European languages is created.
  2. To populate the localized interface strings that are required in the database for each individual double-byte language, from the localization database with the translated strings, do the following:

    1. Change the machine locale from the OS.

    2. Then restart the computer.

    3. Set "NLS_LANG” by going to Control Panel->System->Advanced->Environment Variable->New System Variable.

    • Whenever Oracle Import/Export is used , set the "NLS_LANG"’ value to be: "AMERICAN_AMERICA.UTF8"

    • Whenever AFM products (UPW, AFM Import/Export) is used, set the "NLS_LANG"’ value according to the machine locale:

      • Korean: "AMERICAN_AMERICA.KO16KSC5601"

      • Simplfied Chinese: "AMERICAN_AMERICA.ZHS16GBK"

      • Traditional Chinese: "AMERICAN_AMERICA.ZHT16BIG5"

  3. Export translations from the Sybase project:
    1. While connected to the source Sybase project run: /Technologies/ Localization/ Export or Import Localization Extract Files.
    2. Choose the language, Include All Strings, and comma-delimited (.csv) format.
    3. Click the Export Extract Files button.
  4. Import the translations to the Oracle database:
    1. While connected to the destination Oracle project, run: /Technologies/ Localization/ Export or Import Localization Extract Files.
    2. Choose the language, Include All Strings, and comma-delimited (.csv) format.
    3. Click the Import or Compare Extract Files button.
  5. Use the Localization application to write the localization tables back to the translatable tables. This step will write the strings in lang_strings, lang_enum back to afm_flds_lang, etc. 
    1. While connected to the destination Oracle project, run: /Technologies/ Localization/ Read or Write Translatable Tables.
    2. After making your selections in the form, use the Write Tables action to write the data.