0 = CHAR
1 = SMALLINT
2 = INTEGE R
3 = FLOAT
4 = SMALLFLOAT
5 = DECIMAL
6 = SERIAL *
7 = DATE
8 = MONEY
9 = NULL
10 = DATETIME
11 = BYTE
12 = TEXT
13 = VARCHAR
14 = INTERVAL
15 = NCHAR
16 = NVARCHAR
17 = INT8
18 = SERIAL8 *
19 = SET
20 = MULTISET
21 = LIST
22 = Unnamed ROW
40 = Variable-length opaque type (LVARCHAR)
4118 = Named ROW
如果，某字段要求非空，则在原数字上加256，
如：某字段coltype=262,那么,262-256=6，该字段就应该为：SERIAL not NULL 类型！
马嘉楠
jianan.ma@gmail.com
posted on 2007-10-10 11:33
马嘉楠 阅读(3499)
评论(0) 编辑 收藏 所属分类:
DataBase