INDEX REVISIONS DATATYPES
DataTypes

Constant Types
Basic Alias Name Domain DataD equiv
Basic   tinyint    
Basic   smallint    
Basic   mediumint    
Basic   int    
Basic   bigint    
Basic   float    
Basic   double    
Basic   decimal    
Basic   date    
Basic   datetime    
Basic   time    
Basic   year    
Basic   tinytext    
Basic   mediumtext    
Basic   text    
Basic   longtext    
Basic   tinyblob    
Basic   mediumblob    
Basic   blob    
Basic   longblob    
Basic   enum('a', 'b')    
Basic   set('a', 'b')    
Basic   INTEGER    
Basic   LONGVARCHAR    

Variable Types
Basic Alias Name Size Domain DataD equiv
Basic   float n/a n/a n/a
  Alias float(4,2) 4,2    
Basic   double n/a n/a n/a
  Alias double(8,4) 8,4    
Basic   decimal n/a n/a n/a
  Alias salary 9,2    
Basic   timestamp n/a n/a n/a
  Alias yy 2    
  Alias yy-mm 4    
  Alias yy-mm-dd 6    
  Alias yyyy-mm-dd 8    
  Alias yy-mm-dd-hh-mm 10    
  Alias yy-mm-dd-hh-mm-ss 12    
  Alias yyyy-mm-dd-hh-mm-ss 14    
Basic   char n/a n/a n/a
  Alias char 1    
  Alias bool 1    
  Alias bit 1    
  Alias CHAR80 80    
  Alias CHAR123 123    
  Alias CHAR70 70    
  Alias CHAR100 100    
  Alias CHAR51 51    
  Alias CHAR120 120    
  Alias CHAR255 255    
  Alias CHAR40 40    
  Alias CHAR18 18    
  Alias CHAR36 36    
  Alias CHAR7 7    
  Alias CHAR3 3    
  Alias CHAR2 2    
  Alias CHAR20 20    
  Alias CHAR32 32    
  Alias CHAR50 50    
Basic   varchar n/a n/a n/a
  Alias varchar-255 255    
  Alias VARCHAR32 32    
  Alias VARCHAR30 30    
  Alias VARCHAR7 7    
  Alias VARCHAR60 60    
  Alias VARCHAR9 9    
  Alias VARCHAR50 50    
  Alias VARCHAR18 18    
  Alias VARCHAR23 23    
  Alias VARCHAR36 36    
  Alias VARCHAR101 101    
  Alias VARCHAR180 180    
INDEX REVISIONS DATATYPES