Accessibility
 
Home > Products > ColdFusion > Support > Internationalization
ColdFusion Icon Macromedia ColdFusion Support Center - Internationalization
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 ).

To Table of Contents Back to Previous document Forward to next document