You are viewing a plain text version of this content. The canonical link for it is here.

Posted to ddlutils-dev@db.apache.org by "Thomas Dudziak (JIRA)" <ji...@apache.org> on 2005/09/30 15:43:49 UTC

[jira] Commented: (DDLUTILS-20) Oracle FLOAT and DOUBLE type mappings have zero scale

    [ http://issues.apache.org/jira/browse/DDLUTILS-20?page=comments#action_12330957 ] 

Thomas Dudziak commented on DDLUTILS-20:
----------------------------------------

Actually, this is not the case. If you read the paragraph "Floating-Point Numbers" below the table then you'll see that the scale parameter is not applicable to floating point numbers. As per Oracle 8.1.7 spec, page 2-11:

"NUMBER is a floating-point number with decimal precision 38. Note that a scale value is not applicable for floating-point numbers."

I refrained from using the ANSI datatypes until I have a Oracle 8 database to test against (is in the works).

> Oracle FLOAT and DOUBLE type mappings have zero scale
> -----------------------------------------------------
>
>          Key: DDLUTILS-20
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-20
>      Project: DdlUtils
>         Type: Bug
>     Reporter: Richard Bounds
>     Assignee: Thomas Dudziak

>
> In Oracle8Platform, the types FLOAT and DOUBLE are mapped to NUMBER(38). According to Oracle's docs, this type has zero scale. It looks like floating point numbers should be specified either as just NUMBER or FLOAT(n). See:
> http://oraclelon1.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements001.htm#g196646

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira