mysql raw类型_数据库数据类型对比、数据类型大全

一、Oracle表结构移植到Mysql中需要的类型转换

MYSQL                    ORACLE

BLOB(220)          RAW(220)

BLOB (20)           RAW(20)

BLOG(1024)            RAW(1024)

VARCHAR(n)           VARCHAR2(n)

CHAR                       CHAR

FLOAT(22,6)            NUMBER(22,6)

DOUBLE(44,12)       NUMBER(44,12)

TINYINT (3)              NUMBER(3)

SMALLINT(5)            NUMBER(5)

MEDIUMINT(8)         NUMBER(8)

INT(10)                     NUMBER(10)

BIGINT(20)               NUMBER(20)

DATATIME                DATA

二、mysql和oracle数据类型对应关系参照表

MySQL Data TypeOracle Data Type

NUMERICNUMBER

BIGINTNUMBER(19, 0)

BITRAW

BLOBBLOB, RAW

CHARCHAR

DATEDATE

DATETIMEDATE

DECIMALFLOAT (24)

DOUBLEFLOAT (24)

DOUBLE PRECISIONFLOAT (24)

ENUMVARCHAR2

FLOATFLOAT

INTNUMBER(10, 0)

INTEGERNUMBER(10, 0)

LONGBLOBBLOB, RAW

LONGTEXTCLOB, RAW

MEDIUMBLOBBLOB, RAW

MEDIUMINTNUMBER(7, 0)

MEDIUMTEXTCLOB, RAW

REALFLOAT (24)

SETVARCHAR2

SMALLINTNUMBER(5, 0)

TEXTVARCHAR2, CLOB

TIMEDATE

TIMESTAMPDATE

TINYBLOBRAW

TINYINTNUMBER(3, 0)

TINYTEXTVARCHAR2

VARCHARVARCHAR2, CLOB

YEARNUMBER

数据类型对比(各个数据库)

三、MySQL数据类型：

参见：

NUMERIC[(M[,D])]

These types are synonyms for DECIMAL

DECIMAL[(M[,D])]

If D is omitted, the default is 0. If M is omitted, the default is 10.

TypeStorageMinimum ValueMaximum Value

(Bytes)(Signed/Unsigned)(Signed/Unsigned)

TINYINT1-128127

0255

SMALLINT2-3276832767

065535

MEDIUMINT3-83886088388607

016777215

INT4-21474836482147483647

04294967295

BIGINT8-92233720368547758089223372036854775807

018446744073709551615

TINYINT相当于Java的  Byte (-2^7 ~~~ 2^7-1)

SMALLINT                    Short  (-2^15 ~~~ 2^15-1)

INT                                Integer (-2^31 ~~~ 2^31-1)

BIGINT                          Long    (-2^63 ~~~ 2^63-1)

Numeric

Integer

TINYINT

SMALLINT

MEDIUMINT

INT

BIGINT

Decimal

Single precision

Double precision

Character

Char

Varchar

Text

Binary

Varbinary

BLOB

Date & Time

Date

Time

Datetime

Year

Timestamp

Miscellaneous

ENUM

SET

BIT

四、Oracle数据类型

Character Data Types

VARCHAR2and CHARData Types

NCHARand NVARCHAR2Data Types

Numeric Data Types

NUMBERData Type

Floating-Point Numbers (BINARY_FLOATand BINARY_DOUBLE)

Datetime Data Types

DATE Data Type

TIMESTAMP Data Type (TIMESTAMP WITH TIME ZONE and TIMESTAMP WITH LOCAL TIME ZONE are time-zone aware)