Skip to Main Content

DevOps, CI/CD and Automation

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!

OLE DB localization

icegoodAug 22 2013 — edited Aug 22 2013

select to_number(1.0-.06) from dual

returns 0.94 in sql developer. And it is OK. But in MS SQL linked server via oracle OLE DB returns 0,94.

OS is english with english regional settings and i wonder where ole db provider gets other regional settings.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 19 2013
Added on Aug 22 2013
1 comment
1,236 views