Datatypes

Start Omhoog DML Statements DDL Statements Databasenormalisatie Oefeningen Begrippen Datatypes

Numeric types
Access MySQL MSSQL
Byte 1 byte TINYINT(size)   bigint 1 byte
Integer 2 bytes SMALLINT(size)   smallint 2 bytes
Long 4 bytes MEDIUMINT(size)   int 4 bytes
Single 4 bytes INT(size)   bigint 8 bytes
Double 8 bytes BIGINT(size)   decimal(p,s) 5-17 bytes
Currency 8 bytes FLOAT(size,d)   numeric(p,s) 5-17 bytes
AutoNumber 4 bytes DOUBLE(size,d)   smallmoney 4 bytes
    DECIMAL(size,d)   money 8 bytes
        float(n) 4 or 8 bytes
        real 4 bytes
 
String / tekst types
Access MySQL MSSQL
Text   CHAR(size)   char(n) Defined width
Memo   VARCHAR(size)   varchar(n) 2 bytes + number of chars
Byte 1 byte TINYTEXT   varchar(max) 2 bytes + number of chars
    TEXT   text 4 bytes + number of chars
        nchar Defined width x 2
        nvarchar  
        nvarchar(max)  
        ntext  
        bit  
        binary(n)  
        varbinary  
        varbinary(max)  
        image  
 
Date types
Access MySQL MSSQL
Date/Time 8 bytes DATE()   datetime 8 bytes
    DATETIME()   datetime2 6-8 bytes
    TIMESTAMP()   smalldatetime 4 bytes
    TIME()   date 3 bytes
    YEAR()   time 3-5 bytes
        datetimeoffset 8-10 bytes
        timestamp  
 
Other data types
Access MySQL MSSQL
Yes/No 1 bit     sql_variant  
Ole Object up to 1GB     uniqueidentifier  
Hyperlink       xml  
Lookup Wizard 4 bytes     cursor  
        table