# Data types for AWS Database Migration Service
<a name="CHAP_Reference.DataTypes"></a>

AWS Database Migration Service uses built-in data types to migrate data from a source database engine type to a target database engine type. The following table shows the built-in data types and their descriptions.


|  AWS DMS data types  |  Description  | 
| --- | --- | 
|  STRING  |  A character string.  | 
|  WSTRING  |  A double-byte character string.  | 
|  BOOLEAN  |  A Boolean value.  | 
|  BYTE  |  A binary data value.  | 
|  DATE  |  A date value: year, month, day.  | 
|  TIME  |  A time value: hour, minutes, seconds.  | 
|  DATETIME  |  A timestamp value: year, month, day, hour, minute, second, fractional seconds. The fractional seconds have a maximum scale of 9 digits. The following format is supported: YYYY:MM:DD HH:MM:SS.F(9). For Amazon S3 Select and Amazon S3 Glacier Select, the DATETIME data type format is different. For more information, see the description of the `timestamp` primitive data type in [ Supported Data Types](https://docs.aws.amazon.com/AmazonS3/latest/userguide/s3-glacier-select-sql-reference-data-types.html) of the *Amazon Simple Storage Service User Guide*.  | 
|  INT1  |  A one-byte, signed integer.  | 
|  INT2  |  A two-byte, signed integer.  | 
|  INT4  |  A four-byte, signed integer.  | 
|  INT8  |  An eight-byte, signed integer.  | 
|  NUMERIC   |  An exact numeric value with a fixed precision and scale.  | 
|  REAL4  |  A single-precision floating-point value.  | 
|  REAL8  |  A double-precision floating-point value.  | 
|  UINT1  |  A one-byte, unsigned integer.  | 
|  UINT2  |  A two-byte, unsigned integer.  | 
|  UINT4  |  A four-byte, unsigned integer.  | 
|  UINT8  |  An eight-byte, unsigned integer.  | 
|  BLOB  |  Binary large object.  | 
|  CLOB  |  Character large object.   | 
|  NCLOB  |  Native character large object.   | 

**Note**  
AWS DMS can't migrate any LOB data type to an Apache Kafka endpoint.