数据类型 | 长度(byte) |
smallint | 2 |
integer | 4 |
serial | 4 |
numeric|decimal | default 10 |
decimal(5,1) | 4 |
decimal(10,2) | 6 |
decimal(16,5) | 10 |
smallfloat | 4 |
float | 8 |
char(n) | n |
varchar(1..255) | n |
lvarchar(1..32739) | n |
bigint | 8 |
int8 | 10 |
bigserial | 8 |
serial8 | 10 |
date | 4 |
datetime year to day | 5 |
datetime year to second | 8 |
datetime year to fraction(3) | 10 |
datetime year to fraction(5) | 11 |
informix 数据类型长度整理
最新推荐文章于 2022-10-23 19:08:44 发布