AnsweredAssumed Answered

Numbers format

Question asked by mcanovas on Sep 22, 2010
Latest reply on Sep 27, 2010 by mark
Hi friends!

we have a problem with a number format attributes. When we populate a field
with decimals, then the number is saved wrong.

I've configured the number attribute with 2 decimal places.

For example:

Field input: 1000.9 - After save: 10,009.00
Field input: 1000.09 - After save: 100,009.00

OS information:
My OS is a MS Windows Server 2003 R2 Enterprise x64 Edition service
Pack 2.
Regional and Language Options:
- Tab Regional Options
- Regional Options: English (United States)
- Location: United States
- Tab Advanced
- Language for non-Unicode programs: English (United States)

Clarity information:
I've in account settings my Locale as English(United States).

This is my Oracle database parameters
"PARAMETER"
"VALUE"
"NLS_LANGUAGE"
"AMERICAN"
"NLS_TERRITORY"
"AMERICA"
"NLS_CURRENCY"
"$"
"NLS_ISO_CURRENCY"
"AMERICA"
"NLS_NUMERIC_CHARACTERS"
".,"
"NLS_CHARACTERSET"
"UTF8"
"NLS_CALENDAR"
"GREGORIAN"
"NLS_DATE_FORMAT"
"DD-MON-RR"
"NLS_DATE_LANGUAGE"
"AMERICAN"
"NLS_SORT"
"BINARY"
"NLS_TIME_FORMAT"
"HH.MI.SSXFF AM"
"NLS_TIMESTAMP_FORMAT"
"DD-MON-RR HH.MI.SSXFF AM"
"NLS_TIME_TZ_FORMAT"
"HH.MI.SSXFF AM TZR"
"NLS_TIMESTAMP_TZ_FORMAT"
"DD-MON-RR HH.MI.SSXFF AM TZR"
"NLS_DUAL_CURRENCY"
"$"
"NLS_COMP"
"BINARY"
"NLS_LENGTH_SEMANTICS"
"BYTE"
"NLS_NCHAR_CONV_EXCP"
"FALSE"
"NLS_NCHAR_CHARACTERSET"
"UTF8"
"NLS_RDBMS_VERSION"
"10.2.0.4.0"
Thanks

Outcomes