Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
coltype
860 views
Skip to first unread message
Roger Xu
May 4, 2000, 3:00:00 AM5/4/00
to
Hi,
Can someone help me to interpret coltype in syscolumns system catalog table.
I have coltype=0
coltype=1
coltype=2
coltype=4
coltype=5
coltype=6
coltype=7
coltype=10
coltype=11
coltype=12
coltype=256
coltype=258
coltype=259
coltype=261
coltype=262
Thanks
Roger XU
Database Administrator
Dr Pepper Bottling Company of Texas
2304 Century Center Blvd.
Irving, TX 75062
Demus, Alan
May 4, 2000, 3:00:00 AM5/4/00
to
Unofficially, but this seems to work:
0 - char
1 - smallint
2 - integer
4 - smallfloat
5 - decimal
6 - serial
7 - date
8 - money
10 - datetime
11 - byte
12 - text
13 - varchar
14 - interval
These are "Null Allowed"
The value plus 256 indicates "Not Null"
Other values are not so straighforward
Art S. Kagel
May 8, 2000, 3:00:00 AM5/8/00
to Roger Xu
Check out the header file $INFORMIXDIR/incl/esql/sqltypes.h or
$INFORMIXDIR/incl/tools/sqltypes.h if you have either ESQL-C/SDK or 4GL
installed. Types number > 255 are NOT NULL columns just subtract 256 to
determine the actual type. See also the code in my dbschema replacement
utility, myschema, in the file myschema.ec for complete type and resolution
(for variable length and configurable types like VARCHAR, DECIMAL, and DATETIME)
interpretation sample code.
$INFORMIXDIR/incl/tools/sqltypes.h if you have either ESQL-C/SDK or 4GL
installed. Types number > 255 are NOT NULL columns just subtract 256 to
determine the actual type. See also the code in my dbschema replacement
utility, myschema, in the file myschema.ec for complete type and resolution
(for variable length and configurable types like VARCHAR, DECIMAL, and DATETIME)
interpretation sample code.
Art S. Kagel
0 new messages