1. Home
  2. LLBLGen Pro
  3. LLBLGen Pro Runtime Framework

Oracle Number Conversion

Posts   
 
    
crazylittlemonkeys
User
Posts: 11
Joined: 29-Mar-2005
# Posted on: 02-May-2005 15:43:33   

Does anyone have a list of what different size numbers will convert to when generating code from Oracle? I am asking in regards to integers: NUMBER(x,0).

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39908
Joined: 17-Aug-2003
# Posted on: 02-May-2005 16:31:02   

crazylittlemonkeys wrote:

Does anyone have a list of what different size numbers will convert to when generating code from Oracle? I am asking in regards to integers: NUMBER(x,0).

x < 5: Int16 5 <= x < 10 : Int32 10 <= x < 19: Int64 19 <= x <= 38: Decimal

WITH scale: x < 8: Single 8 <= x < 16: Double otherwise: decimal.

Frans Bouma | Lead developer LLBLGen Pro
netclectic avatar
netclectic
User
Posts: 255
Joined: 28-Jan-2004
# Posted on: 09-May-2005 10:18:55   

crazylittlemonkeys wrote:

I am asking in regards to integers: NUMBER(x,0).

and if x wasn't specified then Oracle defaults to 38 frowning