Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Set correct thousand separator ("space") for Czech locale

Pavel_pOct 19 2011 — edited Nov 30 2011
Hi all,
please, could anybody help me with following problems? In Czech locale we have decimal separator "," and thousand separator " ", but unfortunately when I set primary language in Globalization attributes

Application Primary Language Czech (cs)
Application Language Derived From Application primary language

I have thousand separator ".".

Debug window says:

0.43800 0.00000 alter session set nls_language="CZECH" 3
0.43800 0.00000 alter session set nls_territory="CZECH REPUBLIC" 3
0.43800 0.00000 NLS: CSV charset=EE8MSWIN1250 3
0.43800 0.00000 ...NLS: Set Decimal separator="," 3
0.43800 0.00000 ...NLS: Set NLS Group separator="."

How can I set thousand separator properly for the whole application?
I tried to make a little "workaround" - I created following application process, that is run Before header

BEGIN
EXECUTE IMMEDIATE 'alter session set NLS_NUMERIC_CHARACTERS = '', '' ';
END;

and numbers are shown correctly, but if I set any filter on a report, correct number formatting is gone and thousand separator is again "." until I click the "refresh page" button (after that numbers are again formatted correctly till I add something else to the filter).

Another problem is with a built-in calculator (item type Text field with calculator popup), that propagates "." as a decimal point into the text field instead of "," (according to my locale settings). So if I submit the page then, I get "numeric or value error: character to number conversion error".
Thanks in advance,
Pavel
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 28 2011
Added on Oct 19 2011
3 comments
2,684 views