Clarity

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

Hi All,

Any helpful ideas here?

Thanks!

I can see that your NLS_DATE_FORMAT is wrong, it should be YYYY-MM-DD HH24:MI:SS, but I'm not so sure that is the cause of your problems.

One thing worth trying is setting the java.language and java.country in the JVM parameters of your app server using NSA (you know, the bit where you specify the memory usage) , like this:

-Duser.language=en -Duser.country=US

hope this helps

/Mark