| DB2/400 |
C |
C# |
C/C#数据范围 |
| NUMBER |
Float(n)/REAL/DOUBLE |
double |
double |
1.7E +/- 308 (15 digits)
|
NUMBER(p)
p<=4 |
SAMLLINT
DECIMAL(p)
NUMBER(p) |
short |
Int16 |
–32,768 to 32,767
NUMBER(5)
|
NUMBER(p)
5<=p<=9 |
INTEGER
DECIMAL(p)
NUMBER(p) |
int |
Int32 |
–2,147,483,648 to 2,147,483,647
NUMBER(10)
|
NUMBER(p)
10<=p<=19 |
BIGINT
DECIMAL(p)
NUMBER(p) |
__int64 |
Int64 |
–9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
NUMBER(19)
|
NUMBER(p,s)
p=7 s=3 |
Float(n)
DECIMAL(p,s)
NUMBER(p,s) |
float |
float |
3.4E +/- 38 (7 digits)
|
NUMBER(p,s)
p=15 s=5 |
REAL
DECIMAL(p,s)
NUMBER(p,s) |
double |
double |
1.7E +/- 308 (15 digits)
|
NUMBER(p,s)
p=15 s=5 |
DOUBLE
DECIMAL(p,s)
NUMBER(p,s) |
double |
double |
1.7E +/- 308 (15 digits)
|
Oracle的Numer类型与C,C#数据类型对应关系
标签：程序 its sum 1.7 int 行存储 系统 tab logs
