Database vendors sometimes use different names for similar data types. The table that follows shows the names used in this document and the equivalents used by various database vendors.

This Guide

Oracle

MS-SQL

Sybase

DB2

SOLID

MySQL

char

char

char

char

char

char

char

varchar

varchar2

varchar

varchar

varchar

varchar

varchar

one-digit

number(1,0)

tinyint

tinyint

numeric(1,0)

tinyint

tinyint

tinyint

number(3,0)

tinyint

tinyint

numeric(3,0)

tinyint

tinyint

smallint

number(5,0)

smallint

smallint

smallint

smallint

smallint

integer

number(10,0)

integer

integer

integer

integer

integer

bigint

number(19,0)

bigint

number(19,0)

bigint

bigint

bigint

numeric

number

numeric

numeric

numeric

numeric

numeric

datetime

date

datetime

datetime

timestamp

timestamp

datetime

timestamp

timestamp

datetime

datetime

timestamp

timestamp

datetime

 
loading table of contents...