SQL中的五種資料類型

1.字元型：
sql-92: char,varchar
mysql:char,varchar & & binary,varbinary
mssql: char,varchar & nchar,nvarchar & binary,varbinary
oracle: char, varchar2(varchar), raw, nchar, nvarchar2,
註：varchar,raw必須設定大小

2.文本型
mysql: tinytext, text, mediumtext, and longtext   & tinyblob, blob, mediumblob, and longblob
mssql:  text & ntext & image
oracle: long, long raw, clob, nlob, blob, bfile
3.數值型
3.1整數int
   sql-92: int, smallint
   mysql: tinyint, smallint, mediumint, int, bigint
      mssql:  tinyint, smallint, int, bigint
       oracle:
3.2小數numeric
   sql-92: numeric, float, real(double precision)
   mysql:float, double, decimal(dec)
      mssql: numeric(decimal), float, real
      oracle:number, binary_float, binary_double,
3.3貨幣money
      sql-92:
   mysql:numeric(decimal),float,real
      mssql: money,smallmoney
      oracle:

4.邏輯型
      sql-92:
   mysql:bool(boolean)
      mssql: bit
      oracle:

5.日期型
      sql-92: date,time
   mysql:date,datetime,timestamp,time,year
      mssql: datetime,smalldatetime,timestamp
      oracle:timestamp, timestamp with time zone, timestamp with local time zone, interval year to month, interval day to second