International functions

Comments

rnielsen said on Oct 25, 2002 at 7:50 PM :

From CF-TALK:
For those of you using the locale functions in CFMX beware of significant issues when using SUN JRE 1.4.1

From our testing of CFMX on JRE 1.4.1 we found that all of the following functions returned unexpected results.

LSIsDate()
- Set Locale to "English (UK)"
- Pass LSIsDate() value of "13/12/02" which is Dec. 13 2002 a valid date.
- Returns error of "13/12/02" is an invalid date format.

LSDateFormat()
- Set Locale to "English (UK)"
- Pass LSIsDate() value of "13/12/02" which is Dec. 13 2002 a valid date.
- Returns error of "13/12/02" is an invalid date format.

LSParseDateTime()
- Set Locale to "English (UK)"
- Pass LSIsDate() value of "13/12/02" which is Dec. 13 2002 a valid date.
- Returns error of "13/12/02" is an invalid date format.

Note: Appears almost as though the setlocale() even though when you run function getlocale() it returns the correct label. If you do enter in the "English (US)" formatted date as "12/13/02" the functions work but the LSDate functions do not show any of the localiezed values. ie. Deciembre instead of December if Spanish etc.

LSCurrencyFormat(n,"none")
- Set Locale to "English (UK)"
- Pass LSCurrencyFormat() value of 123456.78
- Returns 123,456.78 (proper except that in locales with different separators the separators do not change)

LSCurrencyFormat(n,"local")
- Set Locale to "English (UK)"
- Pass LSCurrencyFormat() value of 123456.78
- Returns GBP123,456.78 (Localized currency specifier does not work)

Note: Should return local currency specifier but does not.

LSCurrencyFormat(n,"international")
- Set Locale to "English (UK)"
- Pass LSCurrencyFormat() value of 123456.78
- Returns GBP123,456.78 (proper for some locales but shows EURO for many locales that used to be specific to that locale).

Note: For all currencies the thousands separator and other separators do not change regardless of the locale that has been set.

-r- said on May 5, 2005 at 5:04 PM :

That JRE 1.4 problem was reported two and a half years ago!

What's the fix?