THIS IS FRUSTRATING AND DANGEROUS - 03/19/10 03:17 PM
PL/DEV SETTING:
DECIMAL SYMBOL = .
DIGIT GROUP SYMBOL = ,
NLS PARAMETERS:
nls_language = CROATIAN
nls_territory = CROATIA
nls_numeric_characters = empty (derived from nls_territory ,. )
NLS DATABASE PARAMETERS:
NLS_LANGUAGE = AMERICAN
NLS_TERRITORY = AMERICA
NLS_NUMERIC_CHARACTERS = .,
WHY PLDEV IN SLQ/WINDOW USES "derived from nls_territory" when I explicitly want ., ???????????
This is bad! I've allready had few "situations" with this.
EXAMPLE:
When I duplicate row in SQL/WINDOW results with COPY/PASTE, numbers are displayed as "123.45" but after submit requery shows that in database was stored "12345" !!!
DECIMAL SYMBOL = .
DIGIT GROUP SYMBOL = ,
NLS PARAMETERS:
nls_language = CROATIAN
nls_territory = CROATIA
nls_numeric_characters = empty (derived from nls_territory ,. )
NLS DATABASE PARAMETERS:
NLS_LANGUAGE = AMERICAN
NLS_TERRITORY = AMERICA
NLS_NUMERIC_CHARACTERS = .,
WHY PLDEV IN SLQ/WINDOW USES "derived from nls_territory" when I explicitly want ., ???????????
This is bad! I've allready had few "situations" with this.
EXAMPLE:
When I duplicate row in SQL/WINDOW results with COPY/PASTE, numbers are displayed as "123.45" but after submit requery shows that in database was stored "12345" !!!