Database Software

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!

EN_CA decimal separator issue using 10.g jdbc driver

601216Oct 3 2007 — edited Oct 8 2007

The locale on our server is set
to EN_CA.UTF-8

the NLS_NUMERIC_CHARACTERS for en_CA should be '.,' but (.(period) Decimal separator)
Oracle is returning ',.' ( ,(comma) Decimal separator)

Using sql developer ( which is java) and sql*plus in paralell on same workstation/server here returns different results for decimal separator .
sql*plus retuns correct results, where sql developer returns incorrectly)

switching it to EN_US.UTF-8 returns proper results.

Does anyone have any idea on how to fix this. Altering each session to set NLS_NUMERIC_CHARACTERS is not an option right now for our setup.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 5 2007

Added on Oct 3 2007

#database-key-features, #globalization-support

2 comments

4,647 views