Issue 53396 - Number fields show up as currency using Oracle JDBC
Summary: Number fields show up as currency using Oracle JDBC
Status: CLOSED DUPLICATE of issue 11746
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 680m122
Hardware: All Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: Frank Schönheit
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-08-16 14:22 UTC by nephila
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description nephila 2005-08-16 14:22:13 UTC 
I have a number of oracle databases that I connect to with the Base component using the Oracle JDBC 
driver and they all show the same behaviour.
In the table view and query result view all fields that have a NUMBER type show up as a currency.
To get the correct data type I have to select the field heading (selecting the entire column), bring up the 
context menu and change the column format to number.

I have seen this behaviour in all of the milestones that I've used to connect to Oracle (since about m118) 
on both Linux and Mac OS X.
Comment 1 Frank Schönheit 2005-08-17 09:52:00 UTC 
IIRC, the Oracle JDBC incorrectly declares all numeric columns as being currency
values, while in real it wanted to say that the columns are of a type which
*can* be a currency type. Something like this. Need to investigate whether this
can be worked around in OOo.
Comment 2 christoph.lukasiak 2005-09-12 12:10:23 UTC 
correct owner
Comment 3 Frank Schönheit 2005-09-26 12:13:23 UTC 
known as issue 11746

*** This issue has been marked as a duplicate of 11746 ***
Comment 4 Frank Schönheit 2005-09-26 12:16:21 UTC 
closing duplicate