Mega Code Archive

 

Categories / MySQL Tutorial / Data Types

 

Using Data Types from Other Database Engines

MySQL maps data types as shown in the following table. Other Vendor TypeMySQL Type BOOLTINYINT BOOLEANTINYINT CHARACTER VARYING(M)VARCHAR(M) FIXEDDECIMAL FLOAT4FLOAT FLOAT8DOUBLE INT1TINYINT INT2SMALLINT INT3MEDIUMINT INT4INT INT8BIGINT LONG VARBINARYMEDIUMBLOB LONG VARCHARMEDIUMTEXT LONGMEDIUMTEXT MIDDLEINTMEDIUMINT NUMERICDECIMAL