Changing the number pattern used to format currencies in JSP files

Complete the following steps to change the number pattern that is used to format currencies:

Note: The Madisons and Elite starter stores instead use the shopper's locale setting and the JSTL formatNumber tag to format currencies in JSP files.

Procedure

  1. Use the following XML code in the XML file that you are loading into your target database:
    
    <curfmtdesc 
      storeent_id="-1"
      setccurr="FRF"
      language_id="&en_US;"
      numbrusg_id="-4"
      numberpattern="#,##0.00"
    />
    

    Where:

    Variable Meaning
    storeent_id The store or store group ID
    setccurr The three-character ISO 4217 currency code representing the currency that you want to format. This code must appear in the SETCCURR column of the SETCURR table.
    language_id The language ID of the format record
    numbrusg_id The ID of the number usage
    numberpattern The number pattern for the currency that you want to format. The number pattern can contain four different characters: Zero, number sign, period, or comma.
    0
    Zero represents a digit.
    #
    A number sign, represents a digit or an absent zero as a space.
    .
    A period, represents a placeholder for a decimal separator.
    ,
    A comma, represents a placeholder for a grouping separator.
  2. Load the data to the WebSphere Commerce database. For instructions on how to load the data to the database, see Loading the data to the WebSphere Commerce database.