◆◆◆大家帮忙！寻求现在企业还在使用的各种数据库系统不同版本的数据类型列表！只要您将下列数据库系统之一的数据类型发送给我，我将您

Question

补充一下，本贴结贴时间定为下周一（9月23日早）如果您有好的建议请发至[email protected]

Answer 1

foxpro:字符型 C 254 字母、数字型文本
货币型 Y 8 货币单位 价格
数值型 N 20 整数或小数
浮点型 F 20 同"数值型"
日期型 D 8 年/月/日
日期时间型 T 8 年/月/日/时/分/秒
双精度型 D 8 双精度数值
整型 I 4 不带小数点的数值
逻辑型 L 1 真或假（只有两个值）
备注型 M 4 不定长的字母数字文本
通用型 OLE G 4 （对象链接与嵌入）
字符型（二进制） 同前述"字符型"相同，但是当代码页更改时字符值不变
备注型（二进制）  同前述"备注型"相同，但是当代码页更改时备注不变

Answer 2

sqlserver2000bigint
binary
bit
char
datetime
decimal
float
image
int
money
nchar
ntext
numeric
nvarchar
real
smalldatetime
smallint
smallmoney
sql_variant
sysname
text
timestamp
tinyint
uniqueidentifier
varbinary
varchar

Answer 3

sybase11.5binary
bit
char
datetime
datetimn
decimal
decimaln
float
floatn
image
int
intn
money
moneyn
nchar
numeric
numericn
nvarchar
real
smalldatetime
smallint
smallmoney
sysname
text
timestamp
tinyint
varbinary
varchar

Answer 4

ORACLE8.1.7OID                                                                 RAW                                                                 REF                                                                 BLOB                                                                CHAR                                                                CLOB                                                                TIME                                                                REAL                                                                DATE                                                                BFILE                                                               KOTMI                                                               KOTTD                                                               KOKED                                                               TABLE                                                               OCTET                                                               KOTTB                                                               KOTMD                                                               CFILE                                                               KOTAD                                                               FLOAT                                                               NUMBER                                                              KOKED1                                                              DECIMAL                                                             VARCHAR                                                             POINTER                                                             INTEGER                                                             SMALLINT                  
ODCICOST                                                            VARCHAR2                                                            CANONICAL                                                           TIMESTAMP                                                           ODCIOBJECT                                                          LOB POINTER