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