|
Supported currency formats
In ColdFusion MX, the international currency-related CFML functions, such as LSIsCurrency , support the following currency formats that were not supported in earlier versions.
| Locale |
Type attribute value |
Newly supported currency format example for the value 123456.78 |
| English(Australian) |
international |
AUD123,456.78 |
| English(Canadian) |
international |
CAD123,456.78 |
| English(New Zealand) |
international |
NZD123,456.78 |
| English(UK) |
local international |
£123,456.78 GBP123,456.78 |
| French(Belgian) |
none local international |
123.456,78 123.456,78 FB BEF123.456,78 |
| French(Canadian) |
none local international |
123 456,78 123 456,78 $ CAD123 456,78 |
| French(Standard) |
none local international |
123 456,78 123 456,78 F FRF123 456,78 |
| French(Swiss) |
none local international |
123'456.78 SFr. 123'456.78 CHF123'456.78 |
| German(Austrian) |
local international |
öS 123.456,78 ATS123.456,78 |
| Italian(Swiss) |
none local international |
123'456.78 SFr. 123'456.78 CHF123'456.78 |
| Norwegian(Bokmal), Norwegian(Nynorsk) |
none local international |
123 456,78 kr 123 456,78 NOK123 456,78 |
| Portuguese(Standard) |
local international |
123.456,78 Esc. PTE123.456,78 |
| Portuguese(Brazilian)* |
|
12 de outubro de 1954 05h04min30s PST |
| Spanish(Mexican) |
none local international |
123,456.78 $123,456.78 MXN123,456.78 |
| Swedish |
none local international |
123 456,78 123 456,78 kr SEK123 456,78 |
| * In ColdFusion MX for Portuguese (Brazilian), the Java medium time format (for example, 06:55:27) does not work. The short, long, and full formats work as expected; for example, 05h04min30s PST, 5h4min30s PST, and 05:04.
|
Changes to currency formatting, by locale
The following table shows the functions and locales in which ColdFusion MX produces slightly different output than ColdFusion 5.
| Locale |
Function example |
ColdFusion 5 output |
ColdFusion MX output |
| English(Australian) |
LSCurrencyFormat(123456.78,"international") |
USD123,456.78 |
AUD123,456.78 |
| |
LSCurrencyFormat("-1234.56","none") |
(1,234.56) |
-1,234.56 |
| English(Canadian) |
LSCurrencyFormat(123456.78,"international") |
USD123,456.78 |
CAD123,456.78 |
| |
LSCurrencyFormat("-1234.56","none") |
(1,234.56) |
-1,234.56 |
| English (New Zealand) |
LSCurrencyFormat(123456.78,"international") |
USD123,456.78 |
NZD123,456.78 |
| |
LSCurrencyFormat("-1234.56","none") |
(1,234.56) |
-1,234.56 |
| English(UK) |
LSCurrencyFormat(123456.78,"local") |
$123 456.78 |
£123,456.78 |
| |
LSCurrencyFormat(123456.78,"international") |
USD123,456.78 |
GBP123,456.78 |
| |
LSCurrencyFormat("-1234.56","none") |
(1,234.56) |
-1,234.56 |
| English(US) |
LSParseDateTime("23:15:16 4 Sept. 1998")* |
{ts '1998-09-04 23:15:16'} |
invalid date format |
| French(Belgian) |
LSCurrencyFormat(123456.78,"none") |
123 456,78 |
123.456,78 |
| |
LSCurrencyFormat(123456.78,"local") |
123 456,78 F |
123.456,78 FB |
| |
LSCurrencyFormat(123456.78,"international") |
FRF123 456,78 |
BEF123.456,78 |
| French(Canadian) |
LSCurrencyFormat(123456.78,"local") |
123 456,78 F |
123 456,78 $ |
| |
LSCurrencyFormat(123456.78,"international") |
FRF123 456,78 |
CAD123 456,78 |
| |
LSCurrencyFormat("-1234.56","none") |
-1 234,56 |
(1 234,56) |
| French(Swiss) |
LSCurrencyFormat(123456.78,"local") |
123 456,78 F |
SFr. 123'456.78 |
| |
LSCurrencyFormat(123456.78,"international") |
FRF123 456,78 |
CHF123'456.78 |
| German(Austrian) |
LSCurrencyFormat(123456.78,"local") |
123.456,78 DM |
öS 123.456,78 |
| |
LSCurrencyFormat(123456.78,"international") |
DEM123.456,78 |
ATS123.456,78 |
| Italian(Standard) |
LSCurrencyFormat(123456.78,"none") |
12.345.678 |
123.457 |
| Italian(Swiss) |
LSCurrencyFormat(123456.78,"none") |
12.345.678 |
123'456.78 |
| |
LSCurrencyFormat(123456.78,"local") |
L. 12.345.678 |
SFr. 123'456.78 |
| |
LSCurrencyFormat(123456.78,"international") |
ITL12.345.678 |
CHF123'456.78 |
| Portuguese(Brazilian) |
LSCurrencyFormat("-1234.56","none") |
(1.234,56) |
-1.234,56 |
| Portuguese(Standard) |
LSCurrencyFormat("-1234.56","none") |
(1.234,56) |
-1.234,56 |
| |
LSCurrencyFormat(123456.78,"local") |
R$ 123.456,78 |
123.456,78 Esc. |
| |
LSCurrencyFormat(123456.78,"international") |
BRL123.456,78 |
PTE123.456,78 |
| Spanish(Mexican) |
LSCurrencyFormat(123456.78,"none") |
12.345.678 |
123,456.78 |
| |
LSCurrencyFormat(123456.78,"local") |
12.345.678 pta |
123,456.78 |
| |
LSCurrencyFormat(123456.78,"international") |
ESP12.345.678 |
MXN123,456.78 |
| |
LSCurrencyFormat("-1234.56","none") |
-123.456 |
(1,234.56) |
| Spanish(Standard), Spanish(Modern) |
LSCurrencyFormat(123456.78,"local") |
12.345.678 pta |
123.457 Pts |
| |
LSCurrencyFormat(123456.78,"none") |
12.345.678 |
123.457 |
| Swedish |
LSCurrencyFormat(123456.78,"none") |
123.456,78 |
123 456,78 |
* The English(US) medium date format has changed to the Java standard; for example, "Sept 4, 1998 11:15:16 PM" and "11:15:16 PM Sept. 4, 1998" are valid. For a list of valid date formats, see the Java documentation for the java.text.DateFormat class, at http://java.sun.com/j2se/1.3/docs/api/index.html.
Spanish (Standard) and Spanish(Modern) map to the same Java locale, Spanish(Standard) ( ES_es ).
|
|
