Datatypes in Dreamweaver MX-Compatible Database Management Systems

Datatypes in Dreamweaver MX-Compatible Database Management Systems

Datatypes are easier to remember than functions, but knowing the equivalents across several systems can be difficult, if not impossible, for most of us. Unfortunately, if you guess the wrong datatype, you can actually destroy data; so it's important that you have the most precise match possible.

Table A.6: DATATYPES IN DREAMWEAVER MX-COMPATIBLE DATABASE MANAGEMENT SYSTEMS

Category

SQL Server

Access

Oracle

MySQL

Binary

BINARY

 

RAW

BINARY

 

VARBINARY

   

Text/Character

CHAR

 

CHAR

CHAR

 

VARCHAR

TEXT

VARCHAR

VARCHAR

 

NCHAR

 

NCHARN

 
 

NTEXT

 

NCLOB

 
 

NVARCHAR

 

NVARCHAR

 
 

TEXT

MEMO

CLOB

 
    

TINYTEXT,

    

TINYBLOB

    

TEXT, BLOB

    

MEDIUMTEXT, MEDIUMBLOB

    

BIGTEXT, BIGBLOB

Numeric

BIT

YES/NO

 

BIT, TINYINT

 

BITNULL

   
 

NUMERIC

 

NUMBER

 
 

NULLDECIMAL  

   
 

DECIMAL

DECIMAL

 

DECIMAL

 

DECIMAL NULL

   
 

REAL

FieldSize = Single

 

DOUBLE

 

FLOAT

FieldSize = Double

 

FLOAT

 

REAL NULL

   
 

FLOAT NULL

   
 

TINYINT

FieldSize = Byte

 

TINYINT

Numeric (cont.)

SMALLINT

FieldSize = Integer

 

SMALLINT

 

INT

FieldSize = Long

 

INT

 

TINYINT NULL

   
 

SMALLINT NULL

   
 

INT NULL

   
    

MEDIUMINTBIGINT

Date/Time

DATETIME

DATE/TIME

DATE

DATETIME

 

SMALLDATETIME

  

DATE

 

D ATETIME NULL

   
   

TIMETIMESTAMP

TIMESTAMP

   

INTERVAL

YEAR

Currency/Money

SMALLMONEY

CURRENCY

  
 

MONEY

   
 

SMALLMONEY NULL

   
 

MONEY NULL

   

Image

IMAGE

OLE OBJECT

  
   

BFILE

 



Mastering Dreamweaver MX Databases
Mastering Dreamweaver MX Databases
ISBN: 078214148X
EAN: 2147483647
Year: 2002
Pages: 214

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net