Oo缘来是你oO


posts - 120,comments - 125,trackbacks - 0

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 马嘉楠 阅读(3105) 评论(0)  编辑  收藏 所属分类: DataBase

只有注册用户登录后才能发表评论。


网站导航: