|
|
 |
Table 3-1. 資料欄位型態說明
| 資料長度 |
範圍 |
長度 |
| CHAR(n) |
1 £n £3992 |
固定長度 |
| CHAR(n) |
blank padding |
n bytes |
| VARCHAR(n) |
1 £n £3992 |
可變長度 或 依實際資料長度 |
| BINARY(n) |
1 £n £3992 |
n bytes |
| SMALLINT |
-32768 ~ 32767 |
2 bytes |
| INTEGER |
-231 ~ 231-1 |
4 bytes |
| FLOAT |
|
4 bytes |
| DOUBLE |
|
8 bytes |
| DATE |
1900/01/01 ~ |
4 bytes |
| TIME |
秒 (second) |
4 bytes |
| TIMESTAMP |
微秒 (micro-second) |
11 bytes |
| DECIMAL(p,s) |
1 £p £17, 0 £s £p |
(p+1)/2 + 2 bytes |
| SERIAL(n) |
-231 £ n £ 231-1 或自動增加 |
4 bytes |
| LONG VARCHAR |
0 ~ 2G bytes |
|
| LONG VARBINARY |
0 ~ 2G bytes |
|
| FILE |
80 bytes |
20 bytes |
| OID |
fn.pn.sn |
8 bytes |
|
|
|
Copyright
2002 SYSCOM Computer Engineering Co. All rights reserved.
|
|
|
