Provider Information MySQL Column Type Information: bit (char(1)) (BOOL) (size 1) (isfixedlength) bit auto_increment (char(1) auto_increment) (BOOL) (size 1) (isfixedlength) (isautoincriment) tinyint (I1) (size 3) (isfixedlength) tinyint unsigned (UI1) (size 3) (isfixedlength) tinyint auto_increment (I1) (size 3) (isfixedlength) (isautoincriment) tinyint unsigned auto_increment (UI1) (size 3) (isfixedlength) (isautoincriment) bigint (I8) (size 19) (isfixedlength) bigint unsigned (UI8) (size 20) (isfixedlength) bigint auto_increment (I8) (size 19) (isfixedlength) (isautoincriment) bigint unsigned auto_increment (UI8) (size 20) (isfixedlength) (isautoincriment) long varbinary (mediumblob) (BYTES) (size 16777215) (islong) blob (binary large object (0-65535)) (BYTES) (size 65535) (islong) longblob (binary large object, use mediumblob instead) (BYTES) (size 2147483647) (islong) tinyblob (binary large object (0-255) ) (BYTES) (size 255) mediumblob (binary large object) (BYTES) (size 16777215) (islong) varbinary (BYTES) (size 255) (length) binary (BYTES) (size 255) (isfixedlength) (length) long varchar (mediumtext) (STR) (size 16777215) (islong) text (text(0-65535)) (STR) (size 65535) (islong) mediumtext (STR) (size 16777215) (islong) longtext (STR) (size 2147483647) (islong) tinytext (STR) (size 255) char (STR) (size 255) (isfixedlength) (length) numeric (NUMERIC) (size 19) (isfixedlength) (precision,scale) decimal (NUMERIC) (size 19) (isfixedlength) (precision,scale) integer (I4) (size 10) (isfixedlength) integer unsigned (UI4) (size 10) (isfixedlength) int (integer) (I4) (size 10) (isfixedlength) int unsigned (integer unsigned) (UI4) (size 10) (isfixedlength) mediumint (Medium integer) (I4) (size 7) (isfixedlength) mediumint unsigned (Medium integer unsigned) (UI4) (size 8) (isfixedlength) integer auto_increment (I4) (size 10) (isfixedlength) (isautoincriment) integer unsigned auto_increment (UI4) (size 10) (isfixedlength) (isautoincriment) int auto_increment (integer auto_increment) (I4) (size 10) (isfixedlength) (isautoincriment) int unsigned auto_increment (integer unsigned auto_increment) (UI4) (size 10) (isfixedlength) (isautoincriment) mediumint auto_increment (Medium integer auto_increment) (I4) (size 7) (isfixedlength) (isautoincriment) mediumint unsigned auto_increment (Medium integer unsigned auto_increment) (UI4) (size 8) (isfixedlength) (isautoincriment) smallint (I2) (size 5) (isfixedlength) smallint unsigned (UI2) (size 5) (isfixedlength) smallint auto_increment (I2) (size 5) (isfixedlength) (isautoincriment) smallint unsigned auto_increment (UI2) (size 5) (isfixedlength) (isautoincriment) double (R8) (size 15) (isfixedlength) double auto_increment (R8) (size 15) (isfixedlength) (isautoincriment) float (R4) (size 7) (isfixedlength) float auto_increment (R4) (size 7) (isfixedlength) (isautoincriment) double (R8) (size 15) (isfixedlength) double auto_increment (R8) (size 15) (isfixedlength) (isautoincriment) date (DBDATE) (size 10) (isfixedlength) time (DBTIME) (size 6) (isfixedlength) year (I2) (size 4) (isfixedlength) datetime (DBTIMESTAMP) (size 21) (isfixedlength) timestamp (DBTIMESTAMP) (size 14) (isfixedlength) varchar (STR) (size 255) (max length) This list can be created for any initialized source, by choosing [Admin/DBMS data types] and copying from the Results tab.