数据库数据类型对照表

chinanetboy ,QQ:44633197

 

SQL-92

SYBASE

SQL SERVER

ORACLE

POSTGRES

character type

 

 

 

 

character

char(n)

char(n)

char(n)

char(n)

character varying

varchar(n)

varchar(n)

varchar2(n)

varchar(n)

N/A

nchar(n),nvarchar(n)

N/A

N/A

 

national character

unichar(n)

nchar(n)

nchar(n)

 

 

boolean

 

 

boolean/bool

Date/ time type

 

 

 

 

rowversion

timestamp

timestamp

timestamp

timestamptz

N/A

datetime

datetime

date

date

N/A

smalldatetime

smalldatetime

date

date

N/A

date

N/A

date

date

N/A

time

N/A

date

timetz

 

 

 

 

 

integer type

 

 

 

 

integer

int

int

integer

int,int4

N/A

smallint,tinyint

smallint,tinyint,bigint

N/A

bigint,int8 

Decimal type

 

 

 

 

Decimal

numeric(p,s)

numeric(p,s)

number(p,s)/decimal(p,s)

decimal(p,s)

N/A

decimal(p,s)

decimal(p,s)

number(p,s)/decimal(p,s)

decimal(p,s)

N/A

double

double

number

float8

N/A

float

float

float

float4

N/A

real

real

real

float4

other type

 

 

 

 

N/A

money,smallmoney

money,smallmoney

N/A

money

nation text

text

text

clob

serial4,text

N/A

N/A

ntext

nclob

 

N/A

image

image

blob

 

bit/nbit

bit

bit

bit

varbit