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

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.

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.